Exporting Multiple Queries to Excel

[Sara]

Hi,

I would like to export 18 separate queries to an Excel file. I'm using
TransferSpreadsheet Macro. When I put multiple rows in the Macro (one for
each query), it's only doing the first one but not the rest. Am I doing
something wrong or am I going to have to create 18 separate Macros to do
this? This is on Office 2007.

Thanks!

-Sara