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