VBA to export query or table Excel

[Tcurtis]

Good morning. I am currently exporting queries into an excel file using TransferSpreadsheet command.
An example of the line I use for a query is:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qry_Metrics_Top_Ten_All_Corp1", "C:\SAP_Exports\Metrics_Data_PP.xlsx", True

Is there a way to export the query data to a specific tab and a specified location? Like: "C:\SAP_Exports\Metrics_Data_PP.xlsx", tab 1, A2,

 

[Joe4]

Take a look at the different options presented here: https://bytes.com/topic/access/answers/902069-export-queries-excel-specific-sheet-specific-range

 

[Tcurtis]

This works great! Took me just a few minutes and I got my first results back. Thank you!!