Convert Macro

Creating a macro - Writing a Script - Using the API

Convert Macro

Postby saka » Sat Mar 25, 2017 12:25 am

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
Attachments
Pause.xlsm
(26.78 KiB) Downloaded 32 times
Open office 3 on Windows XP
saka
 
Posts: 2
Joined: Fri Mar 24, 2017 5:54 pm

Re: Convert Macro

Postby Zizi64 » Sat Mar 25, 2017 8:12 am

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.
Last edited by Zizi64 on Sat Mar 25, 2017 9:31 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5999
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Convert Macro

Postby saka » Sat Mar 25, 2017 9:01 pm

tnx
Open office 3 on Windows XP
saka
 
Posts: 2
Joined: Fri Mar 24, 2017 5:54 pm

Re: Convert Macro

Postby JeJe » Sat Mar 25, 2017 11:40 pm

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
Openoffice 4.1.2
Windows 8
JeJe
 
Posts: 122
Joined: Wed Mar 09, 2016 2:40 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: Google [Bot] and 8 guests