Specify Excel Workbook Tab On Export

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

Guest

Hello All,
I am looking for a way to export records from Access tables or queries to
Excel where I can specify one or more tabs in one spreadsheet. For example,
when I export sales records, I'd like to specify a tab for each product line
but keep the output in one Excel spreadsheet.

Do I need to look at the Excel object model to find this?

Thanks.
 
This worked great. Was using TransferSpreadsheet but did not realize that
the Range argument controlled this.

Thanks so much for your help with this.
 

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

Exporting multiple queries into Excel workbook tabs 10
Exporting Data to Multiple Tabs in Excel 1
Exporting Data to One Excel Workbook to Several Worksheets 2
Exporting data from an append table into excel without field heade 4
Export to Tab delimited text file 4
Access export to excel produces "unreadable data" 0
Too few parameters exporting to text 14
Exporting pivot tables to excel 1

Back
Top