export a report from access 2003 to excel 2003 using the outputto method
I am using the outputto method to export an access report to excel. Theres no problem there except whenever i close the excel file i keep getting the message: WonLoss is a Microsoft Excel 5.0/95 Workbook. Do you want to overwrite it with the latest Excel Format.
Is there a way to avoid this popup message?
This is the code i am using.
Private Sub cmdTeam_Click()
DoCmd.OutputTo acReport, "rptWonLoss", "MicrosoftExcel 97-10(*.xls)", "C:\Bowling\Weekly\WonLoss.xls", True, ""