Macro question

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?