View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Overwrite existing file without prompt

I am using Excel 97.

When backing up my files I am prompted by a message "file exists do you want
to overwrite" or something to that effect.

Is there a way to override the prompt so that it is just overwritten?

Can someone assist with some code, please?

Thanks

--
Mark