Allow a macro to save over another file
 

I've written a macro which saves a file with a pre existing name, how can I
make the macro say Yes to overwrite the file that already exists?

Any help gratefully received. Thanks in advance.

Allow a macro to save over another file
 

Application.DisplayAlerts = False

turn back on if doing anything else


--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Marie Bayes" wrote in message
...
I've written a macro which saves a file with a pre existing name, how can
I
make the macro say Yes to overwrite the file that already exists?

Any help gratefully received. Thanks in advance.

Allow a macro to save over another file
 

Sandwich the code in

Application.DisplayAlerts = False
'Your code here
Application.DisplayAlerts = True

Regards,
Alan.
"Marie Bayes" wrote in message
...
I've written a macro which saves a file with a pre existing name, how can
I
make the macro say Yes to overwrite the file that already exists?

Any help gratefully received. Thanks in advance.