Save As: Overwrite exiting file w/out dialog

[rkushner]

I want the SaveAs (in a macro) to overwrite the previous version of the same file without prompting the user to confirm. I would be happy to just delete the previous copy of the file to be saved, but I can't figure that out either.

Thanx!!!
This message was edited by rkushner on 2002-03-22 11:25

 

[Mark O'Brien]

I don't know if this will work, but try

<pre>

Application.DisplayAlerts = False

...Your Code....

Application.DisplayAlerts = True</pre>

 

[rkushner]

Thanks very much!!