Overwrite existing file without prompt

M

Mark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
How can I overwrite the last line data in text or csv file from VB 1
Skip Override Prompt in Macro 3
Excel SaveAs to force overwrite of extant file 1
Overriding the overwrite confirmation prompt 2
Word macro that can call cells out of Excel for a find and replace 0
Saving files automatically 2
Override dialogue prompt for overwrite during export 2

Top