Thread: If user says "No" to FileSaveAs Overwrite?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
OceansideDJ OceansideDJ is offline
external usenet poster
  
Posts: 5
Default If user says "No" to FileSaveAs Overwrite?
Harald,
If the user picks "No" to the overwrite, I want to ask for another filename.

Currently, if the the user picks "no", I get runtime error 1004, Method
"SaveAs of object '_Workbook' failed.

Could I detect error 1004?
Reply With QuoteReply With Quote