savint to a file with seperate worksheets

[Swifey]

I current output 4 queries to a separate file - Is it possible to save the 4 queries into one file? For example: One work file which contains a separate worksheet for every query.

Regards
Swifey

 

[Philem]

Hullo. This is certainly possible. One assumes that you are doing this through code. In the section for each query that gives it a destination, make sure that you are referencing the correct Sheet name.

HTH

P

 

[Swifey]

Thank you for your response
Do I define the sheetname with a ! as follows?

DoCmd.OutputTo acQuery, "Qry 1 ", "MicrosoftExcelBiff8(*.xls)", "C:\My Documents\Customer\file!sheetname1.xls", False, "", 0

DoCmd.OutputTo acQuery, "Qry 2 ", "MicrosoftExcelBiff8(*.xls)", "C:\My Documents\Customer\file!sheetname2.xls", False, "", 0

Swifey

 

[Swifey]

I have tried the subsequent code to save 2 queries to one file with a spreadsheet for every query. My output is still saved to seperate files. Can you please highlight were I am going wrong.

DoCmd.OutputTo acQuery, "Qry 1 ", "MicrosoftExcelBiff8(*.xls)", "C:\My Documents\Customer\filename1!sheetnameQry1.xls", False, "", 0
DoCmd.OutputTo acQuery, "Qry 2 ", "MicrosoftExcelBiff8(*.xls)", "C:\My Documents\Customer\filename1!sheetnameQry2.xls", False, "", 0


Regards
Lynda