[Solved] Where are macros stored...??
[Solved] Where are macros stored...??
I'm on a WinXP computer and have some simple macros I have created which I'd like to share with my office computer. Where can I find them?
Last edited by DWFII on Fri Feb 26, 2010 3:55 am, edited 1 time in total.
Open Office 3.3 on Win7 Pro x64
Re: Where are macros stored...??
If they are written in Basic and they are stored in the Standard library of MyMacros, then they are in a location like
C:\Documents and Settings\username\Application Data\OpenOffice.org\3\user\basic\Standard
For simple macros it might be easier to just copy the code out of the Basic IDE into a Writer document and paste from there into the Basic IDE of your office computer.
C:\Documents and Settings\username\Application Data\OpenOffice.org\3\user\basic\Standard
For simple macros it might be easier to just copy the code out of the Basic IDE into a Writer document and paste from there into the Basic IDE of your office computer.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Where are macros stored...??
Thank you for the response...
Along the same lines, I don't quite understand how macros are "organized."When I open the "organize macros" window I have to drill down through about three levels to get to the macros I've created or use. Being the cautious sort, I have not tried to change this hierarchy but I am wondering if I can just create a top-level "folder" and move all my macros into it rather than "Open Office Basic">"My Macros">"Standard">"Module 1>."
When I want to run a macro I have to click three times before I can even select the macro I want.
Along the same lines, I don't quite understand how macros are "organized."When I open the "organize macros" window I have to drill down through about three levels to get to the macros I've created or use. Being the cautious sort, I have not tried to change this hierarchy but I am wondering if I can just create a top-level "folder" and move all my macros into it rather than "Open Office Basic">"My Macros">"Standard">"Module 1>."
When I want to run a macro I have to click three times before I can even select the macro I want.
Open Office 3.3 on Win7 Pro x64
Re: Where are macros stored...??
You can assign keystrokes (starting with Alt or Ctrl, for example) to the macros. Then you don't have to bother drilling down. You do have to remember the keystrokes though!DWFII wrote:Thank you for the response...
Along the same lines, I don't quite understand how macros are "organized."When I open the "organize macros" window I have to drill down through about three levels to get to the macros I've created or use. Being the cautious sort, I have not tried to change this hierarchy but I am wondering if I can just create a top-level "folder" and move all my macros into it rather than "Open Office Basic">"My Macros">"Standard">"Module 1>."
When I want to run a macro I have to click three times before I can even select the macro I want.
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)
Re: Where are macros stored...??
There is a single collection of Baisc libraries stored in two different locations:
<install_directory>/basis3.1/share/basic/ = [OpenOffice.org Macros, read-only, installed with the program, "Depot", "Euro", Gimmicks", "Tools",...]
<user_profile>/basic/ = [My Macros, read-write, starts with empty lib "Standard"]
"Single collection" means that you can not add library "Tools" to "My Macros" because there is one already in the installation folder.
Every file in that hierarchy is plain XML, accessible with your text editor (except for encrypted modules).
Both folders have one file script.xlc where the libraries are registered.
A typical entry in a script.xlc registering a library "FormWizard":
Both folders have one file dialog.xlc where the libraries with dialogs are registered.
A typical entry in a dialog.xlc:
The entries in the .xlc files point to some folder and a file script.xlb and dialog.xlb where each module (or dialog respectively) is registered.
A typical entry in script.xlb registering a module "Language"
A typical entry in dialog.xlb registering a dialog "DlgFormDB"
Modules are saved as .xba files, dialogs are stored with suffix .xdl
You find the exact same hierarchy of folders, xlc, xlb, xba and xdl files within office documents.
<install_directory>/basis3.1/share/basic/ = [OpenOffice.org Macros, read-only, installed with the program, "Depot", "Euro", Gimmicks", "Tools",...]
<user_profile>/basic/ = [My Macros, read-write, starts with empty lib "Standard"]
"Single collection" means that you can not add library "Tools" to "My Macros" because there is one already in the installation folder.
Every file in that hierarchy is plain XML, accessible with your text editor (except for encrypted modules).
Both folders have one file script.xlc where the libraries are registered.
A typical entry in a script.xlc registering a library "FormWizard":
Code: Select all
<library:library library:name="FormWizard" xlink:href="$(INST)/share/basic/FormWizard/script.xlb/" xlink:type="simple" library:link="true" library:readonly="false"/>
A typical entry in a dialog.xlc:
Code: Select all
<library:library library:name="FormWizard" xlink:href="$(INST)/share/basic/FormWizard/dialog.xlb/" xlink:type="simple" library:link="true" library:readonly="false"/>
A typical entry in script.xlb registering a module "Language"
Code: Select all
<library:element library:name="Language"/>
Code: Select all
<library:element library:name="DlgFormDB"/>
You find the exact same hierarchy of folders, xlc, xlb, xba and xdl files within office documents.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 1160
- Joined: Mon Oct 08, 2007 1:26 am
- Location: France, Paris area
Re: Where are macros stored...??
Hi,
Menu Tools > Macros > Organize Macros... > OpenOffice.org Basic
you can customize the Standard toolbar to add a button that directly opens the dialog OpenOffice.org Basic Macros: You will have to do this once for each OpenOffice.org application you need : Writer, Calc etc.
Alternatively you could create a keyboard shortcut to call the dialog.
If you mean :DWFII wrote:When I want to run a macro I have to click three times before I can even select the macro I want.
Menu Tools > Macros > Organize Macros... > OpenOffice.org Basic
you can customize the Standard toolbar to add a button that directly opens the dialog OpenOffice.org Basic Macros: You will have to do this once for each OpenOffice.org application you need : Writer, Calc etc.
Alternatively you could create a keyboard shortcut to call the dialog.
Bernard
OpenOffice.org 1.1.5 / Apache OpenOffice 4.1.1 / LibreOffice 5.0.5
MS-Windows 7 Home SP1
OpenOffice.org 1.1.5 / Apache OpenOffice 4.1.1 / LibreOffice 5.0.5
MS-Windows 7 Home SP1
Re: Where are macros stored...??
Thanks. I took your advice. Worked like a charm.FJCC wrote:If they are written in Basic and they are stored in the Standard library of MyMacros, then they are in a location like
C:\Documents and Settings\username\Application Data\OpenOffice.org\3\user\basic\Standard
For simple macros it might be easier to just copy the code out of the Basic IDE into a Writer document and paste from there into the Basic IDE of your office computer.
Open Office 3.3 on Win7 Pro x64