View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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
.

.