Automatically replace existing file on save

  • Thread starter Thread starter ronber
  • Start date Start date
R

ronber

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
 
Ron

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

Regards

Trevor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003 16
Save As Then Replace Bombs Out 2
Replace file without being prompted to save 2
Help with copying a sheet from One workbook to another workbook 1
Automatic replace of VBA code for multiple files 4
Making Directory if None Exists 5
Replace an Existing File 2
File already exists. Do I want to replace? 2

Back
Top