Go Back   Access World Forums > Microsoft Access Discussion > General

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

Thanks

DJBummy is offline   Reply With Quote
Reply

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
[SOLVED] 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 06:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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