turn off the " replace file?" question when saving excel files
 

I want to be able to over write a lot of existing Excel files but do not want
to be asked if I want to overwrite the existing file each time

turn off the " replace file?" question when saving excel files
 

Hi
application.displayalerts=false
'save file
application.displayalerts=true

--
Regards
Frank Kabel
Frankfurt, Germany
"Dave Parkes" <Dave schrieb im Newsbeitrag
...
I want to be able to over write a lot of existing Excel files but do not
want
to be asked if I want to overwrite the existing file each time