exporting to excel

[Shirley]

I have multiple tables to be exported to one excel file
but in different worksheet (tab). It seems the Access only
allows me to export the data to one new excel file and the
data is pasted to the first tab.

Any help is greatly appreciated.

Thanks,

shirley

 

[sandra]

I had the same problem, but managed to get round it by
using the following code:

DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel9, "QueryName", "FilePathToSaveTo",
False, "NameOfWorksheet"

Hope this helps!