Automatically replace existing file on save
 

VBA code:

I want to replace an existing file with a file of the same name in the
same directory. I want to do so bypassing the warning message box. How
can I do that?

TIA
Ron



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Automatically replace existing file on save
 

Ron

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

Regards

Trevor


"ronber" wrote in message
...
VBA code:

I want to replace an existing file with a file of the same name in the
same directory. I want to do so bypassing the warning message box. How
can I do that?

TIA
Ron



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/