Insert a key function in VBA script

Good evening Bowes13

Use this command at the start of your code:

Application.DisplayAlerts = False

and this at the end of your code:

Application.DisplayAlerts = True

This will force the macro to not ask you a question, but choose the default option on your behalf (which would be OK - overwrite the file).

HTH

DominicB

What if my default is No?

Hi Bowes813

What I said in my answer was correct, but I think perhaps I could have explained it a little better. this command will set your default value for the question to true and answer the question for you. Indeed, this is what the Excel 2003 help file has to say about the DisplayAlerts property:

"When using the SaveAs method for workbooks to overwrite an existing file, the 'Overwrite' alert has a default of 'No', while the 'Yes' response is selected by Excel when the DisplayAlerts property is set equal to True."

HTH

DominicB