setwarnings in macro doesnt work

Paul200968

Registered User.
Local time
Today, 10:31
Joined
Apr 3, 2006
Messages
14
Hi,

I have created a macro with 2 lines:
1) setwarnings is no
2) output to excel file.

When I run this marco it will prompt that this file exists. I thought this wasnt the case when you setwarings to no.

If I use VB with docmd.setwarnings false it does not prompt me??

Could somebody help me out so that the macro builder wont show me this prompt with setwarnings to no?

rgrds,

Paul.
 

Users who are viewing this thread

Back
Top Bottom