| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overriding the overwrite confirmation prompt
Is there a way to modify the line below so that if the file "Project
Status.txt" already exists, it will automatically be overwritten without prompting the user to confirm the overwrite? ActiveWorkbook.SaveAs Filename:="Project Status.txt", _ FileFormat:=xlText, CreateBackup:=False Thanks in advance for any help. Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Supress Confirmation Prompt | Excel Programming | |||
| Overwrite Prompt with Save As | Excel Programming | |||
| Save as Overwrite prompt | Excel Programming | |||
| Prompt to overwrite | Excel Programming | |||
| Avoiding Overwrite Confirmation | Excel Programming | |||
Threaded Mode
