saveas method question

[martyman]

is there an overload for the saveas method that will force an overwrite of the existing file?

[JB · Accepted solution]

Hi martyman,

if you don't want the Messagebox "Overwrite, yes/no" then use

application.DisplayAlerts = False

before SaveAs.

Reset to True after saving...