[Solved] How do I backup macros

Using them, Making them , Finding them

[Solved] How do I backup macros

Postby ds947u » Sun Dec 20, 2015 4:39 pm

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
ds947u
 
Posts: 20
Joined: Tue Dec 23, 2008 10:07 pm

Re: How do I backup macros.

Postby Villeroy » Sun Dec 20, 2015 4:41 pm

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 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25703
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How do I backup macros.

Postby MTP » Mon Dec 21, 2015 5:19 pm

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
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: How do I backup macros.

Postby ds947u » Sat Dec 26, 2015 10:41 pm

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
ds947u
 
Posts: 20
Joined: Tue Dec 23, 2008 10:07 pm


Return to Templates

Who is online

Users browsing this forum: No registered users and 1 guest