John Jason Jordan wrote:
The problem now is trying to figure out the maze of how macros are
stored in OOo. I tried the Help and I have never read such a confusing
mess. It talks about libraries and modules and lots of other stuff as
though I know what they are. Or as if I care. All I want is every macro
I have ever created to be available in any document on my computer.
I was gone for the weekend so this may be too late to be of any help.
Figuring out where macros are located and copying from one library to
another can be accomplished in at least one way. Here is the one I know:
1. Open one or more files that do or might contain macros of interest
to you.
2. Click Tools > Macros > Organize Macros > OpenOffice.org Basic
3. Here you will a window named "Macros from", and in that window ia a
tree-structure with several levels. I'm not sure of the official
terminology so I'll call the highest level "SuperLibraries. These look
like 3-D rectangles with names like "My Macros" and "OpenOffice.org
Macros'" There will also be a SuperLibrary with the name of one of the
files you have open.
4. SuperLibraries contain Libraries. If a SuperLibrary is not open
there will be a "*" in front; if it is open there will be a "-" in front
and the Libraries will appear below as
yellow-gold boxes with a "+" or "-" in front; a "+" means that Library
is not open but does contain Modules of Macros. To open a SuperLibrary
or Library either dbl-click it or click the "+".
5. Click on any Module of interest. The macros it containswill be
listed in the the box entitled Existing macros in : ....
6. Once you find the Library, Module and Macro of nterest, click the
Edit button on the far right.
7. This brings up a window whose title will be of the form:
"SuperLibrary.Library - OpenOffice.org Basic" Across the bottom of
this window will be a series of tabs with the various module-names on
them. Below the third line of the main window is a Basic text-editing
window containing the code for the macros(s) in the module. Doubtless
you've been here before since you've already written macros.
8. On the 3rd line of the main main window, just above the tsxt-editing
window is a drop-down menu-box. This is the key to moving code from
library to library. Clicking the arrow for the drop-down box gives you
direct editing access to the other SuperLibraries and Libraries.
9. My approach therefore is to copy the text (using Ctrl+C) in one
module, use the drop-down box to get to the desired new location, create
the appropriate blank Module/tab there, and paste-in the text.
10. There may be more elegant approaches, but this at least works.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
