Replace Existing File
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
|