Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 03-08-2006, 07:23 AM   #1
Newly Registered User
Join Date: Jun 2001
Location: Pennsylvania
Posts: 90
Thanks: 2
Thanked 1 Time in 1 Post
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, ""
End Sub


DJBummy is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display excel file contents in access report? tigger345 Reports 1 02-07-2006 02:05 AM
editing excel from access report tim the enchant Reports 0 05-12-2005 02:51 AM
Access Report to Excel Ice Rhino Reports 5 05-10-2005 12:35 AM
export report to excel question style Reports 3 12-15-2004 04:29 AM
Excel to Access ASharifs Queries 1 01-24-2003 05:03 AM

All times are GMT -8. The time now is 05:07 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World