Export Query Data From Access into an Existing Workbook need to tweak existing code

[SunnyG]

Hello Everyone,

Could someone please help me tweak the code below. I want to export the query data from Access into an existing Excel workbook instead of creating a new workbook for it. There are a total of 9 queries and each has a specific tab it needs to go into the same workbook. Also, I would like to overwrite the data in the tabs each week when I run this. Any help would be greatly appreciated. I m getting a headache from this!

Below is the code for 1 tab, it works fine but I don't want a new excel workbook created which is what this does, I would like the data to go into an existing workbook.

DoCmd.TransferSpreadsheet acExport, , "Dashboard 1 - Exception Status", "\\corp\dfs\Retail_Shared\GA016\F3A_02\RETAIL_SHARED\AQCP\WBCS Admin\WBCS Analytics\REPORTING\Weekly\DTS\DTS Dashboard Master.xls", False, "Dashboard_1"

Thank you,

Lisa

 

[llkhoutx]

Look carefully at the TransferSpreadSheet function arguments.

 

[SunnyG]

Thank you, thread has been solved.