Export multiple Queries to same Workbook Cant overwrite Content

[Wapug]

I have an access db where I have written code to export the results of three queries to an excel workbook. The workbook will contain, or may contain data from previous exports and I would like to have the new data from my db overwrite the existing data in the workbook.
I have used the TransferSpreadsheet method to export the three queries. How can I add code that will delete any existing data on the three tabs in the target workbook?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qBacon", strpath

 

[Ranman256]

The export does not erase the previous data.
Can you just erase the workbook, then export?

 

[June7]

Bing: access export to excel and overwrite

One approach https://answers.microsoft.com/en-us...ing-data/fc1ae248-6353-4c3a-b44a-e41dd6e969a8

 

[Mark_]

MMmmmmmm......qBacon......

 

[Wapug]

The export does not erase the previous data.
Can you just erase the workbook, then export?

I don't want to delete the entire workbook because it contains multiple other sheets with information that is needed.