Exporting Access to Excel (specific tab)

J

Jim/Chris

Try this
This will not export to a sheet but create/overwrite the
sheet named in the workbook. If there is existing
information on the existing sheet in the workbook then
export tjis to another sheet and reference the data in the
main sheet in the workbook.


DoCmd.TransferSpreadsheet acExport, 8, "Query or table
name", "full file name", False, "sheet name"

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Using ExportSpreadsheet 1
VBA - exporting serial letters to single documents 0
Export Access pivot table to Excel 0
Export Report with Graph to Excel error 2495 1
Access export to excel produces "unreadable data" 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Transfer Spreadsheet method: Sheet Name 5
2 queries in one exported workbook 0

Top