S
Stapes
Hi
I am using the following command to put the results of a query in to
an excel spreadsheet:
DoCmd.OutputTo acOutputQuery, "Emission Trading Log", _
acFormatXLS, "ETL.xls", True
I end up with a file called "ETL.xls" with a Worksheet called
"Emission Trading Log". Is there any way that I can create more than
one worksheet with this command - each with a different name? I want
one sheet for each trader.
Stapes
I am using the following command to put the results of a query in to
an excel spreadsheet:
DoCmd.OutputTo acOutputQuery, "Emission Trading Log", _
acFormatXLS, "ETL.xls", True
I end up with a file called "ETL.xls" with a Worksheet called
"Emission Trading Log". Is there any way that I can create more than
one worksheet with this command - each with a different name? I want
one sheet for each trader.
Stapes