| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically overwriting files
Greetings,
I have the following VBA code which saves a text file to a certain folder. However, if that file already exists, it displays a dialog box asking me if I want to overwrite the existing file. I always want to answer "Yes" to this dialog. However, I won't always know if a file by that same name already exists before the code is run. That means that the dialog will not always appear. I guess I could use Sendkeys, but that would only work if an existing file by that same name would always be in that folder. Any idea as to how to get around this? ActiveWorkbook.SaveAs Filename:="C:\filename.txt", FileFormat:=xlText, _ CreateBackup:=False -- Thanks in advance! Sherwood |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically overwriting files
Hi Sherwood
Before the save Application.DisplayAlerts = False amd after the save Application.DisplayAlerts = True -- Regards Ron de Bruin http://www.rondebruin.nl "Sherwood" wrote in message ... Greetings, I have the following VBA code which saves a text file to a certain folder. However, if that file already exists, it displays a dialog box asking me if I want to overwrite the existing file. I always want to answer "Yes" to this dialog. However, I won't always know if a file by that same name already exists before the code is run. That means that the dialog will not always appear. I guess I could use Sendkeys, but that would only work if an existing file by that same name would always be in that folder. Any idea as to how to get around this? ActiveWorkbook.SaveAs Filename:="C:\filename.txt", FileFormat:=xlText, _ CreateBackup:=False -- Thanks in advance! Sherwood |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically overwriting files
Thanks, Ron. I appreciate it.
-- Sherwood "Ron de Bruin" wrote: Hi Sherwood Before the save Application.DisplayAlerts = False amd after the save Application.DisplayAlerts = True -- Regards Ron de Bruin http://www.rondebruin.nl "Sherwood" wrote in message ... Greetings, I have the following VBA code which saves a text file to a certain folder. However, if that file already exists, it displays a dialog box asking me if I want to overwrite the existing file. I always want to answer "Yes" to this dialog. However, I won't always know if a file by that same name already exists before the code is run. That means that the dialog will not always appear. I guess I could use Sendkeys, but that would only work if an existing file by that same name would always be in that folder. Any idea as to how to get around this? ActiveWorkbook.SaveAs Filename:="C:\filename.txt", FileFormat:=xlText, _ CreateBackup:=False -- Thanks in advance! Sherwood |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert rows automatically to avoid overwriting | Excel Discussion (Misc queries) | |||
| Where do I find the files that have been automatically saved? | Excel Discussion (Misc queries) | |||
| FILES CREATED AUTOMATICALLY WHILE SAVING | Excel Discussion (Misc queries) | |||
| Want to Unzip files automatically | Excel Programming | |||
| Overwriting a file automatically using saveas in a macro | Excel Programming | |||
Linear Mode
