export a report from access 2003 to excel 2003 using the outputto method (1 Viewer)

DJBummy

Registered User.
Local time
Today, 11:14
Joined
Jun 22, 2001
Messages
90
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, ""
End Sub

Thanks
 

Users who are viewing this thread

Top Bottom