Thread: If user says "No" to FileSaveAs Overwrite?
View Single Post
  #1   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?
My macro asks the user for a FileSaveAsName, then tries to save the file with:

ActiveWorkbook.SaveAs Filename:=sFileSaveName, ...

How can I tell if the user gets the "File exists, Overwrite?" prompt, and
answers "no"?

Thanks
Reply With QuoteReply With Quote