Replace Existing File

[Lynn]

I am using the following code to save the active workbook:

ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls"

How can I get it to select Yes if prompted to Replace the Existing File?

[Dave Peterson]

application.displayalerts = false
ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls"
application.displayalerts = true

Will save without a prompt.

Lynn wrote:
>
> I am using the following code to save the active workbook:
>
> ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls"
>
> How can I get it to select Yes if prompted to Replace the Existing File?

--

Dave Peterson

[Lynn]

Thanks Dave!

"Dave Peterson" wrote:

> application.displayalerts = false
> ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls"
> application.displayalerts = true
>
> Will save without a prompt.
>
> Lynn wrote:
> >
> > I am using the following code to save the active workbook:
> >
> > ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls"
> >
> > How can I get it to select Yes if prompted to Replace the Existing File?
>
> --
>
> Dave Peterson
>