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
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.
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.
PLEASE!!!!
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-10-05 22:48:56 +0200
Seen: 815 times
Last updated: Feb 22
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
