vba Open Office question

[Rockerdo]

I have some folks that may need to open an excel macro enabled spreadsheet (2010) in Open Office.

I can convert the macro from 2010 excel to open office, I believe.

Do I need to have two versions of the file? I had some people try to use the 2010 excel file in open office and were getting errors or when they sent it back to me the functionality was totally gone.

Want to make this as painless as possible for those that need to use this file. The company is not willing to give all the users full version of 2010 excel which would make this so much easier!

 

[Eric W]

According to this post:

https://wiki.openoffice.org/wiki/Documentation/FAQ/Macros/Can_I_use_my_Microsoft_Office_macros?

macros written in VBA can't be used in Open Office. You'll have to tweak them to have the same functionality, although theoretically the syntax should be similar.

Good luck!

 

[RoryA]

Many macros in Excel can be run in Ooo though. From that page:

OpenOffice.org 3 Calc can execute many Excel macros, but (for security reasons) you must manually enable this feature

 

[Rockerdo]

So I converted the macro to what will work in open office. I'll have them retest and see what happens.

Will the Converted code work in regular excel too or should I save it twice and have two versions?

 

[Eric W]

I have very little experience with Open Office, so I can't speak directly to it. However, I've had other experiences with cross-assemblers/cross-interpreters, and even though they say that they can handle different languages, there are often subtle errors that are hard to find. My personal recommendation would be to save two versions. Granted, not the best situation because you now have two sources to maintain, but both versions are probably more trustworthy.

 

[Macropod]

Depending on what the two environments provide, you may be able to have a single macro branch, as required, depending on whether the macro is being run in Excel or in Calc.