Specify Excel Workbook Tab On Export

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

 

[Guest]

Use the Range argument of the TransferSpreadsheet to identify the sheet name.

 

[Guest]

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

Thanks so much for your help with this.