title: A file named "XX\Data\AccNum.xls' already exists in this location. Do you want to replace it?
body: <p>Could someone throw some light on here.The below code works absolutely but it keeps bothering me with: </p>
  
  <blockquote>
    <p>A file named "XX\Data\AccNum.xls" already exists in this location. Do you want to replace it?</p>
  </blockquote>
  
  <p>For all rows. </p>
  
  <p>For several times, I'll have to click yes for rest of the code to execute. I've tried <code>displayAlert=False</code>, <code>applicationalerts=false</code>. no luck.   </p>
  
  <pre><code>For Iterator = 1 To AccNoRow Step 1
  
      Set AccNoTB=browser("title:=.*").page("title:=.*").webtable("column names:=;Account No;Account Name;Billing City;Website;Phone;Assigned To;Action","cols:=8")
  
      'open excel &amp; write to it
  
      Set Fso=createobject("Excel.application")
      Set file =fso.workbooks.open("XX\Data\AccNum.xls")
      file.worksheets("sheet1").cells(Iterator,3).value=AccNoTB.GetCellData(Iterator,3)
      fso.ActiveWorkbook.saveAs "XX\Data\AccNum.xls"
      fso.quit
  Next
  
  Set fso=nothing
  Set file=nothing
  </code></pre>