Hi,
I have Access button with this command:
DoCmd.TransferS preadsheet acExport, acSpreadsheetTy peExcel9, "MYS", "C:\SERVICE AWARD PROGRAM\REPORTS \reports.xls", True, "MYS"
It transfer Access query named 'MYS' to an Excel file name report.xls.
Everytime I click the button, I want to rewrite existing report generated previously.
How can I do that? Right now it did not rewrite the existing report.
I have Access button with this command:
DoCmd.TransferS preadsheet acExport, acSpreadsheetTy peExcel9, "MYS", "C:\SERVICE AWARD PROGRAM\REPORTS \reports.xls", True, "MYS"
It transfer Access query named 'MYS' to an Excel file name report.xls.
Everytime I click the button, I want to rewrite existing report generated previously.
How can I do that? Right now it did not rewrite the existing report.