English
Ask Your Question
0

Import MS-Word Macros ...

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

Frank1000 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 close merge delete

2 answers

Sort by » oldest newest most voted
1

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

stfhell gravatar image

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

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
0

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

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!!!!

edit flag offensive delete link more

Comments

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 ( 2014-10-06 13:38:37 +0100 )edit
Login/Signup to Answer

Question Tools

Follow
1 follower

Stats

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

Seen: 7,764 times

Last updated: Feb 22 '13