saveas method question

Valued Contributor
Valued Contributor

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

1 REPLY

Re: saveas method question

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Hi martyman,

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

application.DisplayAlerts = False

before SaveAs.

Reset to True after saving...

regards

JB
VS2015, SE ST10