title: Saveas issue Overwrite existing file ( Excel VBA)
body: <p>I have the following macro that is correct except for the <code>SaveAs</code> gives me an error if I click <code>No</code> or <code>Cancel</code>,if I click <code>yes</code> is working fine. </p>
  
  <pre><code>ActiveWorkbook.SaveAs Filename:=FileName, FileFormat:=xlWorkbook, ConflictResolution:=xlLocalSessionChanges
  
  Application.DisplayAlert =True
  </code></pre>
  
  <p>But when I come to <code>SaveAs</code> part I get the following error when I select <code>No</code> to the save.
   Excel message: <strong>A file named " ......... " already exists in this location. Do you want to replace it</strong>? I click 'No' or <code>cancel</code> and get the run time error 1004 ....
  Method <code>SaveAs</code> of object <code>_Workbook</code> failed. </p>
  
  <p>I don't want to use the <code>Application.DisplayAlerts = False</code>, because I want the user to be aware that there is a file already named the same. </p>
  
  <ol>
  <li>Why do I get this error? Why can't I select 'No'</li>
  <li>What other option do I have to display that the file is already
  there and select <code>No</code> or <code>Cancel</code>and not get the run-time error.?</li>
  </ol>