It's always worked for me, too.

But maybe you could just kill the existing name first.

on error resume next
kill myFileNameWithPathHere
on error goto 0
'do your save

The "on error resume next" says to ignore any error if the file doesn't actually
exist.



doesn't apply wrote:

displayalerts does not work with the overwrite msgbox of SaveAs!

----- Frank Kabel wrote: -----

Hi
use
application.displayalerts = false
before your statement and
application.displayalerts = True
after this

-----Original Message-----
I don't see this option in saveas. Is there another way
to avoid the overwite dialog box when overwriting a file
with a macro?
Thanks
.


--

Dave Peterson