Transfer Data to Specified Excel tab

  • Thread starter Thread starter jw22
  • Start date Start date
J

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