saveas method question

[#1]

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

[#2 · 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...