title: Overwrite existing csv file using vba
body: <p>When I use this vba code to save a newly created csv file, I get a dialogue box asking whether I should overwrite an existing csv file that has the same file name.  How do I always get the new csv file to overwrite an existing file (if it exists)?:</p>
  
  <pre><code>Workbooks.Add
  ActiveWorkbook.SaveAs Filename:=strOutput, FileFormat:=xlCSV
  ActiveWorkbook.Close savechanges:=False
  </code></pre>