title: How to save an Excel sheet as CSV so that no quotes are contained in the exported file?
body: <p>Okay, so I want to have a macro in Excel 2003 which saves the current worksheet as a .txt file. I've already got that part with the following code:</p>
  
  <pre><code>Dim filename As String
  Dim path As String
  filename = InputBox("Please enter file name", "Save as CSV", "CSV_" &amp; Format(Now, "DD_MM_yyyy"))
  path = "C:\Temp" &amp; filename &amp; ".txt"
  
  ActiveWorkbook.SaveAs filename:=path, FileFormat:=xlTextMSDOS, CreateBackup:=False
  </code></pre>
  
  <p>But now to the actual problem: In my sheet there are some cells which contain a comma. If I use the macro shown above, the file gets saved as CSV, but the cells containing a comma have quotation marks around them. I do not want that.
  If I save the file manually via File -> Save as -> CSV/TXT, the resulting file does not contain these quotation marks.</p>
  
  <p>Does anyone know how to solve this problem?</p>
  
  <p>Many thanks!</p>
  
  <p>Edit: I forgot to say that, when saving manually, I select Text tab-seperated, and not comma-seperated.</p>