Page 1 of 1
Convert Macro
Posted: Sat Mar 25, 2017 12:25 am
by saka
Hello everyone,
I'm new here, and I need help.
Is there a possibility that this excel table converts into open office but also to transfer all VBA codes to work as well as in the office. I do not know how to konverutjem VBA codes and whether it can at all.
thank in advance
Re: Convert Macro
Posted: Sat Mar 25, 2017 8:12 am
by Zizi64
The MS VBA and the API+StarBasic are not compatibile. You must use the native fileformats and must rewrite all of your macros based on the Application Programming Interface of the AOO, if you want work with the macros efficiently in the Apache OpenOffice.
Or you can try the LibreOffice: it has a littlebit higher compatibility with the MS VBA macro codes.
But it is strongly recommended to use the International Standard, native ODF fileformats anyway.
Re: Convert Macro
Posted: Sat Mar 25, 2017 9:01 pm
by saka
tnx
Re: Convert Macro
Posted: Sat Mar 25, 2017 11:40 pm
by JeJe
At the top of a module you can put the following.
Option Compatible ' VBA compatibility on.
Option ClassModule ' (VBA) Make module as class module.
Option VBASupport 1 ' Switch VBA suppport mode, Compatible is also on. 0 to turn it off
Compatability with VBA isn't complete. I've found the ability to use a class module very useful though
https://wiki.openoffice.org/wiki/Category:VBA