Thread: Replace Existing File
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lynn Lynn is offline
external usenet poster
  
Posts: 131
Default Replace Existing File
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?

Reply With QuoteReply With Quote