Export Using ExportSpreadsheet

[WilliamJ via AccessMonster.com]

When I try exporting crosstab query results to a workbook and specifically a
tab or sheet in that workbook, Access creates a new tab everytime. I want to
replace the existing data in the tab or sheet with the new query results. Is
their a way to always drop the results into the same tab or sheet?

Here is my DoCmd statement

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "DataForExport",
"S:\Data\TestData", , "Sheet2"

 

[Ken Snell]

See this article -- it may give you some insights on what is happening and
what you need to do to make it work the way you want:

Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange