Hi Dick, > I've used OOo Base to construct a database and wrote a macro in Basic to > connect to the database, issue an SQL query and write out a report of > statistics calculated from the results of the query. All work very well. > Now I'd like to write another macro that issues a different query and > processes the results. However, OOo wants to append the new macro to the > previous one. No matter what I try, it will not let me write the new > macro as a separate entity. What am I missing here?
Not sure I understand what you mean with "append the new macro to the previous one" ... Macros in OOo are organized into libraries, with a library containing (one or) multiple modules, with a module containing (one or) multiple functions/subs. The Basic organizer (via "Tools/Macros/Organize Macros/StarOffice Basic .../Organizer") will allow you to manipulate this structure. If playing with the organizer doesn't help you, please elaborate the problem. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
