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.
 
Back
Top