Tue 15 Jan 2008, 09:39Delegate Doug said...
Doug has attended:
No courses
Output To within Access Macros
Hi,
I am using 'Output To' in my macro to run a query and then export it into an Excel sheet.
The Excel file I am exporting into is the same one each time, hence I get the message:
"The file 'xxxxx' already exists. Do you want to replace the existing file?"
How can I set this to 'yes' as a default so I don't have to click 'yes' everytime?
Best wishes,
Doug.
Tue 29 Jan 2008, 14:02Trainer Carlos said...
RE: Output To within Access Macros
Hi Doug
There is a line of code in VBA that suspends any Warnings/Alerts.
In the Macro just before your Output To code line try using
Application.DisplayAlerts=False
And immediately after the Output To code line use
Application.DisplayAlerts=True
Hope this helps
Carlos
