When you edit a macro, you load the library, which makes the macro
available.
Tools > Macros > Organize Macros > OpenOffice.org Basic
The "Macro from" list on the left side of the dialog is a list of macro
library containers. Expand the library container with your macro; for
example, My Macros or a specific document.
The libraries are then shown. If you expand the "OpenOffice.org Macros"
library container, you will see libraries with names like Depot, Euro,
FormWizard, Gimmicks, ImportWizard, launcher, Tools...
Click on the + sign next to the library. The library expands and you can
see the containing modules. This causes the library to load. Notice that
the icons for the library change.
dg wrote:
On Fri, 2007-07-27 at 23:47 -0400, Andrew Douglas Pitonyak wrote:
Thank you so much for your kind and fast answer, I tried everything in
the documentation to no avail. can you please give me, at your earliest
convenience, all details on how to :
"explicitly load the library containing the worker macro"
Best regards
D.Gaudry
dg wrote:
Daniel Gaudry Ph. D.
9 Avenue calmels
92270 Bois Colombes
FRANCE
[EMAIL PROTECTED]
HI
I wrote a small macro but it is not available in my spreadsheet with the
message #NAME?. How can I load it?
Many thanks
Regards
D.Gaudry
First, let me mention that this is discussed in the Macro chapter of the
Calc documentation
http://documentation.openoffice.org/manuals/oooauthors2/
Hmm, but I see that it is not yet available. Strange. if you send me an
email, I will send it to you.
It is also mentioned in AndrewMacro.odt.
That said, the bottom line is that the library containing the macro must
be loaded and visible.
First, about "visible". A macro is visible to a document if the macro is
contained in that document, or if the macro is contained in one of the
global macro libraries ("My Macros" or OpenOffice.org).
As for loaded, if you load the macro browser and click on a library,
that loads the library. I usually place the macros that I want to call
as a Calc function in Standard (because the library named Standard is
always loaded automatically), or I at least place the called macro in
Standard and then I explicitly load the library containing the worker
macro before I call it.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
