View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default Do you want to replace it?

From VB script, when executing the code:

ActiveWorkbook.SaveAs FileName:="C:\ZZ.XLS"

a dialogue comes up when the file exists already, requesting whether the
filename should be overwritten. How can I retrieve the option exercised by
the user: YES, NO, CANCEL?