| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overriding the overwrite confirmation prompt
application.displayalerts = false
activeworkbook.saveas .... application.displayalerts = true Bob wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overriding the overwrite confirmation prompt
Dave,
Thanks a million! Bob "Dave Peterson" wrote: application.displayalerts = false activeworkbook.saveas .... application.displayalerts = true Bob wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
