Creating Multiple Tab Excel Output File

[Sue]

Hi
Trying to output 3 queries and create just 1 excel .xls or .csv file with 3
tabs. Is this possible please? If so how do I do it?

Cheers
Sue

 

[Jeanette Cunningham]

Sue,
you can export the 3 queries, one after the other using Transfer Spredsheet.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryOne", _
"C:\Documents and Settings\Jeanette\Desktop\MyFile.xls"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryTwo", _
"C:\Documents and Settings\Jeanette\Desktop\MyFile.xls"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryThree", _
"C:\Documents and Settings\Jeanette\Desktop\MyFile.xls"

The above will give you 3 tabs in the same workbook.


Jeanette Cunningham -- Melbourne Victoria Australia