Hi Dick, > OK, here are the steps I went through to create a second macro.
ah, *that's* a useful problem description :) > 1. I double-clicked on my dbase to activate Base. > 2. I then selected TOOLS -> MACROS -> ORGANIZE MACROS -> OpenOffice.org > Basic. That opened a window with a box that displayed a list of items > including my dbase. > 3. Clicking on the "+" to the left of my dbase dropped down a folder > named "STANDARD". > 4. Clicking on the "+" to the left of STANDARD revealed it contained a > Macro named "Stat1" which is the first macro I wrote. I want to create > another macro in this folder called STANDARD. > 5. I click on the folder called STANDARD to highlight it, type the new > macro name "Species" in the box provided and select "NEW" on the right. > 6. A window opens to enter the Basic code with the Basic statements > "Sub Species" and "End Sub" already provided. The statements for the > macro "Stat1" are visible above the "Sub Species" statement so this new > macro is being appended to the previous one. > 7. I enter the rest of the code for "Species" and close the window. (For > some reason, the provided "End Sub" is not recognized and I have to > enter another one.) I again look at what macros are listed in STANDARD > and only "Stat1" is listed. If I highlight "Stat1" the list of macros on > the right now shows "Stat1" and "Species" as macros. If I highlight > "Species" and select RUN only that macro executes, which is OK. Okay, we have a terminology problem here. "Standard" is the name of a Basic library. As said, libraries contain multiple "modules" - you have one named "Stat1", which is displayed in the left hand side tree view below the "Standard" node. However, you *also* have a *sub routine" called "Stat1", which is located in the *module" "Stat1". The steps you describe create a new *sub routine* in the existing *module* named "Stat1". Try the following: Open "Stat1" for editing (select it in the dialog, and press the "Edit" button, so the Basic IDE opens). At the bottom of the window, you'll see a small tab named "Stat1". Open its context menu, and choose "Insert / BASIC module". This will create a new module, indicated by a second tab, and default-named "Module1". When you now open the organizer dialog, again, you'll note that below the "Standard" node in the tree, there's two entries: "Stat1" and "Module1" => you're done :) 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]
