On Sat, 2007-07-28 at 09:07 -0400, Andrew Douglas Pitonyak wrote: Many thannks It works now ! Regards D.Gaudry > 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. > >> > >> > -- Daniel Gaudry Ph. D. 9 Avenue calmels 92270 Bois Colombes FRANCE
+336 64 19 50 09 [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
