Save As without overwrite prompt

[Fred Smith]

I want to overwrite an old file without getting prompted as to whether it's
OK.

Is there something I can specify on the SaveAs command? Or do I delete the
old file first (if it's there)?

 

[Cesar Zapata]

Hi,

use the

application.displayalerts = false
thisworbook.save
application.displayalerts = true

 

[Tom Ogilvy]

a nitpick, but you shouldn't need that with save for a workbook that has
been previously saved, but as the OP specified SAVEAS

application.displayalerts = false
thisworbook.saveas . . .
application.displayalerts = true