Page 1 of 1
[Solved] How do I backup macros
Posted: Sun Dec 20, 2015 4:39 pm
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
Re: How do I backup macros.
Posted: Sun Dec 20, 2015 4:41 pm
by Villeroy
Together with your regular backup of all user data which should include all your documents and the %APPDATA% folder.
Re: How do I backup macros.
Posted: Mon Dec 21, 2015 5:19 pm
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
Re: How do I backup macros.
Posted: Sat Dec 26, 2015 10:41 pm
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.