[Solved] How do I backup macros

Using them, Making them, Finding them
Post Reply
ds947u
Posts: 28
Joined: Tue Dec 23, 2008 10:07 pm

[Solved] How do I backup macros

Post by ds947u »

I am learning to write macros in OO and need some way to save/backup & transport code to other computers with OO.
Can I simply copy the code to a thumb drive & install the macros on another copy of OO?
Where are the macros stored in windows/linux?


Thanks, Hank
Last edited by Hagar Delest on Sun Mar 19, 2017 7:03 pm, edited 1 time in total.
Reason: tagged [Solved].
OOo 2.4.X on MS Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How do I backup macros.

Post by Villeroy »

Together with your regular backup of all user data which should include all your documents and the %APPDATA% folder.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
MTP
Volunteer
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: How do I backup macros.

Post by MTP »

If you are using the OpenOffice macro editor (for macros written in Basic), you can save the macro code in its own file by opening the macro editor, and finding the "Save BASIC" icon on the macro toolbar. It looks like a sheet with lines on it with a floppy disk in front of the sheet.

Clicking on the "Save BASIC" icon with prompt you to give your module a name and save it with the extension .bas
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
ds947u
Posts: 28
Joined: Tue Dec 23, 2008 10:07 pm

Re: How do I backup macros.

Post by ds947u »

MTP wrote:save the macro code in its own file
Thank you. That was what I needed to know.
Will give it a try.

I assume the code is basic when recording macros in OO??
Looked at the file "Module1.xba" seems basic-like but with with deep qualification levels.
OOo 2.4.X on MS Windows Vista
Post Reply