overriding replace dialog box in saveAs method

[mech55]

Hi, I'm trying to find out how to get rid of the dialog that asks if you want a replace a file if you're saving a new file with the same name to the a directory that contains a file with that name. Basically I want to have it so that it Always overrides and saves the new file over the old one without a pop up box. Is there a way to do this?

[Bob Phillips]

Application.DisplayAlerts = False

'your code

Application.DisplayAlerts = True