We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Import MS-Word Macros ... [closed]

asked 2012-10-05 22:48:56 +0200

Frank1000 gravatar image

updated 2015-10-22 23:30:32 +0200

Alex Kemp gravatar image

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 flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-22 23:30:57.698273

2 Answers

Sort by » oldest newest most voted

answered 2012-10-18 20:09:37 +0200

stfhell gravatar image

updated 2012-10-18 20:10:29 +0200

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.

edit flag offensive delete link more

answered 2013-02-22 01:02:00 +0200

WritingGirl gravatar image

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.


edit flag offensive delete link 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.

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

Question Tools

1 follower


Asked: 2012-10-05 22:48:56 +0200

Seen: 36,971 times

Last updated: Feb 22 '13