Thread: turn off the " replace file?" question when saving excel files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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


Reply With QuoteReply With Quote