title: VBA - file saves as tab-delimited instead of csv
body: <p>I'm getting slightly confused by this issue. I have a macro that grabs data from one spreadsheet, re-formats it and saves in another spreadsheet. Everything works perfectly well but this piece of code seems to be working incorrectly:</p>
  
  <pre><code>Set NewBook = Workbooks.Add
          With NewBook
          .Title = "Pts"
          .SaveAs Filename:="C:\Minestar_exports\" &amp; Pts &amp; "", FileFormat:=xlCSV, 
   CreateBackup:=False
          .Close
          End With
  </code></pre>
  
  <p>The trouble is that it save the file all right but seems to ignore the <strong>FileFormat:=xlCSV</strong> bit and saves it as TAB-delimeted instead. It's no biggie, when macro finishes running I just overwrite the temporary file using proper file format but still I couldn't figure out why this is happening. Any suggestions? </p>