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