Andrew Douglas Pitonyak wrote: > I have two specific problems. > > PROBLEM: > > I have a Calc document containing macros that calls a custom DLL that > calls a database. The database must be opened before the other macros > will work. I associated the "open document" event to the "open database > macro". > > The Calc document contains formulas that call the macros. Unfortunately, > every formula is called, and THEN the open document event is fired, > which attempts to open the database. I hacked a solution using a global > variable in the document, and I am able to catch the error, open the > database, and then reconnect. Is there a better event for me to use with > this calc document to open the DB before the formulas are called?
That depends on if there is a way to prevent formulas from being calculated before loading of the document completely finished as this is the first point in time where an event is fired. This is not the "OnLoad" event as you can read in a current discussion on [EMAIL PROTECTED] Ciao, Mathias -- Mathias Bauer (mba) - Project Lead OpenOffice.org Writer OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't reply to "[EMAIL PROTECTED]". I use it for the OOo lists and only rarely read other mails sent to it. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
