How to export to a specific excel worksheet?

[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.

 

[Lynn Trapp]

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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[paco paz via AccessMonster.com]

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.

 

[Lynn Trapp]

Yes, you put the name of your Access table in the place of "YourTableName."
You put the name of your excel FILE in the place of "C:\YourSpreadsheet.xls"
and put the name of the sheet (if you want it to have a different name than
your Accesstable name) in the place of "SheetName".

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html