Thread: How check for No/Cancel Button when SaveAs and file already exists?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
  
Posts: 92
Default How check for No/Cancel Button when SaveAs and file already exists?
Hello -

I get an error if I press either No or Cancel in the prompt that Excel
will show if the file already exists:
Run-time error '1004'
Method 'SaveAs' of object '_Workbook' failed.
Is there a way to catch that?

Thanks,
Joe

Reply With QuoteReply With Quote