How to export to a specific excel worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,


I need to export a query to a specific excel worksheet.

I use the "transfertspreadsheet" method.
How do I specify the worksheet?

By default it pastes the data into a new sheet with the name of the excel
workbook.
 
Hello, i can´t understand how to put this code, can you help me please, how?

In this code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"YourTableName", "C:\YourSpreadsheet.xls", , "SheetName"

"YourTableName" - Here im put the name of my table to access or to excel?

Can you send me to a complete example, please.
 
Back
Top