Hi

I am wanting to output a number of queries to a single excel document (system created)
I would like to result of each query to be on a seperate worksheet.

Is any of this possible??

Thankyou

Hi

This thread will help?



Link to Previous Thread

regards

mike

Erm.

I dont really know, seems very complicated to me, also it uses a PREFormatted excel file which I do not have!

I have found a way that you can export the 3 queries, one after the other using Transfer Spreadsheet.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryOne", "C:\...MyFile.xls"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryTwo", "C:\...MyFile.xls"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryThree", "C:\...MyFile.xls"

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