Changing Defaults in VBA 2

  • Thread starter Thread starter JohnUK
  • Start date Start date
J

JohnUK

I need a code that opens a workbook, and then saves it as
another workbook that already exists, without it telling
me, the file already exists, do you want to replace it?
I just want it to do it without it asking me.
When you want this done on a dozen workbooks, it gets a
bit tedious keep pressing the yes button, when everything
else runs through smoothly via code.
Many thanks in advance
John
 
John
Put these statements before and after the code that saves the workbook:
Put This Statement Before The Statement That Results In An Alert.

Application.DisplayAlerts = False



Put This Statement After The Statement That Results In An Alert.

Application.DisplayAlerts = True

HTH Otto
 

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

Back
Top