Specify Excel Workbook Tab On Export

S

ScottS

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

ScottS

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

Thanks so much for your help with this.
 
Top