Jack Gillis wrote:
----- Original Message ----- From: "Andrew Douglas Pitonyak" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, April 23, 2005 1:11 PM
Subject: Re: [users] Global Macros for Calc
Jack Gillis wrote:
I need to make several macros available for all Calc spreadsheets, both new and old. I found, in the FAQs, how to make a macro globally accessible however the description mentions the 'soffice' library object. I can find it in 1.1.4 but not in 1.9.95. There is apparently a change in library structure in the later version. Can some one give me a hint how to proceed? And can I limit the 'globalness' to Calc only?
There is primarily a change in the user interface, not in the implementation (as far as storage locations is concerned). I could explain it, but that would take time and I already documented this...
http://documentation.openoffice.org/manuals/
Download the document titled "Getting started with macros". This is a modified chapter one from my book to reflect one of the few changes wiht the new release of OOo. I address your issue around page 6.
I do not believe that you can limit the "globalness" to only Calc documents, but you can verify that you have a Calc document in the Macro itself.
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php
Thank you very, very much Andrew.
I have your original book on the subject and it will be a great help as I wean myself from Microsoft Office. In fact, I was just about to email you asking you the question I posed but decided to wait and see if I got a reply from the list. 'Lo and behold, there you were.
The documentation site you gave me has a whole lot of good stuff in addition to what I was interested in at the moment and I'm sure I will be going back to it often.
Thanks again.
Excellent. From the Macro and API perspective, functionally, very little has changed apart from Database. More accurately, what you used to know, typically works.
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
