| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| accidentally click YES to overwrite an existing file | Excel Discussion (Misc queries) | |||
| Using SaveAs Statement to overwrite existing File | Excel Programming | |||
| Write over existing file with no Prompt | Excel Programming | |||
| Save As without overwrite prompt | Excel Programming | |||
| Prompt to overwrite | Excel Programming | |||
Threaded Mode
