Transfer Data to Specified Excel tab

[jw22]

I am sending queries to an Excel workbook via Transferspreadsheet in Macros.
Is it possible to specify a name that a query transfers to Excel as?

i.e. Transfer Query [IC_BRT_Report] to a tab named "BRT" in Excel, not a
tab named "IC_BRT_Report".
Thanks.
jw22

 

[Ken Snell MVP]

Exporting to an existing worksheet that was not originally created by a
TransferSpreadsheet action may have some problems. See this article:
Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ExpRange

Best approach is to rename the query to the same name as the worksheet, but
that too may not be successful if the worksheet was not created originally
by a TransferSpreadsheet action.