Reply
Solved! Go to solution

saveas method question

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

1 REPLY
Solution
Solution
Accepted by topic author martyman
‎02-13-2017 12:22 PM

Re: saveas method question

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