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

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

Application.DisplayAlerts = False

"your code

Application.DisplayAlerts = True

Gord Dibben Excel MVP

On Thu, 16 Sep 2004 20:16:35 -0500, "Steven K0" wrote:

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?