First time here? Check out the FAQ!
asked 2012-10-05 22:48:56 +0200Frank1000
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 ?
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.
answered 2013-02-22 01:02:00 +0200WritingGirl
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.
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: 800 times
Last updated: Feb 22