Overwriting a file automatically using saveas in a macro
Hi
works for me.you may post the relevant part of your code
-----Original Message-----
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
.
.
|