Hi Steven,

Try:

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

End Sub

---
Regards,
Norman



"Steven K0" wrote in message
...
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?

--
Thanks in advance,
Steven