Displayalerts off without having to take default option for Save as etc.

[Annette]

Hi all

Is there any way that I can disable display alerts
without having to take the default option of the alert?

For example, one of my macros is used by other users.
This macro opens a file and saves it to another
directory - over a file of the same name that already
exists.

At the moment my macro brings up the display alert asking
me whether I want to save over the file. The default for
this built in dialogue is "No".

If I turn displayalerts off then the system chooses the
default value and the file is not saved. So at the moment
I have an extra step of user interaction that I don't
want.

There must be a clever way that the Microsoft bods have
come up with that allows you to turn the alerts off and
also choose the action that you want

Any ideas?

Ta
Annette

and I do not want them to see a display alert when the
fil

 

[Mike Fogleman]

Have a look at CopyFile Method in which Overwrite = True is the default.
Mike

 

[Bob Phillips]

Annette,

If you set displayalerts to false, SaveAs will save automatically, it
doesn't not save it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Annette
I just tried it (just to be sure). But disabling the alerts before
saving the file WILL save the file, even if it does exist before.