Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Our office often get infected with VBA virus (don't know why). We have encountered VBA virus that inject macro to excel sheets, there have been macro that run whenever a new excel sheet is open etc.

SO we're consider to use OpenOffice to replace Microsoft Office thinking that OpenOffice should be able to evade most VBA Macro virus - is that true?

share|improve this question
    
What VBA virus are you referring to? Plus this question would be better asked on Stack Overflow where the VBA experts are –  brettdj Feb 18 '12 at 8:02
    
as this is more an application usage, i think it more appropriate here than SO, but more people think that so, i'll move it. –  KMC Feb 18 '12 at 8:30
    
As you are having VBA issues then they may be solvable - better to look at cure first rather than moving apps for prevention. cheers –  brettdj Feb 18 '12 at 9:09
2  
Office 2007 onwards also support macro-free documents which get any macros stripped out when saving. Tell your people that when they save a document they need to "save as" then change the format to the macro-free format. xlsx is the Excel macro-free extension, and docx is the Word macro-free extension. –  Mokubai Feb 18 '12 at 12:03
1  
it would be best to determine the source of the macros. They maybe in someone's personal.xls (depending upon version) and so that is the actual source that is injecting it. But you can set security in all versions to not allow macros unless you authorize them –  datatoo Feb 18 '12 at 17:59
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.