I'm trying to export two queries to two different Excel tabs. Sounds pretty simple right? They are existing tabs in the Excel workbook and when I try it creates a new tab with the title and a 1 at the end of it. I'm using this code below:



DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Output_SP_30_Day_Cancels", "C:\newtest.xls", True, "Comp%_and_Cancels_By_Month"

I've tried putting a "!" at the end of the name ""Comp%_and_Cancels_By_Month!" but it still doesn't work.

Any ideas?