SaveAs without prompt

[Steven K0]

Hello,

Is there a way to overwrite a file with SaveAs without being prompted with a
dialog box? Or do you have to delete the file first and then save?

 

[Norman Jones]

Hi Steven,

Try:

Sub Test()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs "YourFileName" '<<<== CHANGE
Application.DisplayAlerts = True

End Sub

 

[Gord Dibben]

Application.DisplayAlerts = False

"your code

Application.DisplayAlerts = True

Gord Dibben Excel MVP