Automatically overwriting files

[Guest]

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

 

[Ron de Bruin]

Hi Sherwood

Before the save
Application.DisplayAlerts = False

amd after the save
Application.DisplayAlerts = True

 

[Guest]

Thanks, Ron. I appreciate it.
--
Sherwood

Hi Sherwood

Before the save
Application.DisplayAlerts = False

amd after the save
Application.DisplayAlerts = True