English

# Import MS-Word Macros ...

Hi, I'm working on switching from MS-Word to LibreOffice. I have lots of Macros I created in Word and started reading into importing them into LibreOffice. As it seems they need kind of "translation" which is doen automatically.

When I open the normal.dot in LO then I get all the macros and they do work when I run them (some adjustments needed. But when I copy them into the My Macros/Synadartd/Module1 then the same macros do not work any more ... guess this is because of the translation needed.

Also I wanted to import the shortcuts I use for the macros if that is possible.

Any experience around on how this works ?

Regards, Frank

edit retag close merge delete

Sort by » oldest newest most voted

No real experience, really. But OO and LO incorporate (limited) direct support for VBA (language and office object model). This is used with MS native file formats automatically. In ODF/ODS files you have to enable VBA support at the beginning of the macro, otherwise it expects LO-Basic:

Option VBASupport 1
Option Compatible


But be prepared for difficulties. And keep in mind that LO does not store its own macros in MS office file formats. Conversion to the LO-Basic and UNO object model have to be done by hand, although there is a simple online converter from business-spreadsheets.com.

more

I have hundreds of Word macros created over a decade or more, with several dozen that I use literally all the time, so much so that I am lost without them.

Not being able to translate these easily (preferably automatically) is very disappointing, what with Microsoft's new licensing policies, I can see that my long love affair with Word is destined to end at some point. Very upsetting.

PLEASE work on Word VBA translation/convertion to LO.

more

I have the same problem with excel and calc. lot of Visualbasic and no way to move on calc because libroffice basic has no or very poor or hard to find documentation. I trust in development but it is hard to switch.

( 2014-10-06 13:38:37 +0200 )edit