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

Hi Sherwood

Before the save
Application.DisplayAlerts = False

amd after the save
Application.DisplayAlerts = True


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sherwood" <[email protected]> wrote in message news:[email protected]...
> 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

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" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>
>