Changiing defaults in VBA
 

Can anyone help me with this one - I need a code that
over writes the defaults when saving a document. For
example, when opening a workbook from one location and
saving into a different location with a file with the
same name, I need it to save without the "This file
already exists, do you want to replace the existing
file?" The default is set to NO, but I need it to be YES
Many thanks in advance
John

Precede with

Application.DisplayAlerts = False

and reset afterwards.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JohnUK" wrote in message
...
Can anyone help me with this one - I need a code that
over writes the defaults when saving a document. For
example, when opening a workbook from one location and
saving into a different location with a file with the
same name, I need it to save without the "This file
already exists, do you want to replace the existing
file?" The default is set to NO, but I need it to be YES
Many thanks in advance
John