Overwrite existing file without prompt
 

Application.DisplayAlerts = False
Activeworkbook.SaveCopyAs "C:\Backups\Backup1.xls"
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"Mark" wrote in message
...
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