Export to a excel Spreadsheet

[Lanason]

I've done a search but cant find an answer

I'm trying to send data to a spread sheet to create a graph etc

im using :-

'    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryCrosstab", "S:\Database\myspreadsheet.xlsx", True

however when I re-run it creates a new tab - how can I overwrite the initial tab

 

[Ranman256]

exporting data should not create a new tab. It always export to the same tab ESPECIALLY if you name it:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, sQuery, sFile, True,tabname