H
HELP
I am new to VBA. I am trying to export multiple queries into Excel. However,
I would like them to appear in different tabs. Each query in its own tab.
Currently it is pasting all the queries on one sheet. Below is what I have in
the database:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "ActualSales",
"C:\Scorecard Data\Test", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "GrossInv",
"C:\Scorecard Data\Test", True
Any help would be appreciated.
Thank you
I would like them to appear in different tabs. Each query in its own tab.
Currently it is pasting all the queries on one sheet. Below is what I have in
the database:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "ActualSales",
"C:\Scorecard Data\Test", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "GrossInv",
"C:\Scorecard Data\Test", True
Any help would be appreciated.
Thank you