Excel VBA Save as tab delimited file
<p>I have some code that saves the active worksheet as a tab delimited text file, however the cell data that has a comma character in them gets exported with quotation marks, like</p>

<pre><code>John Hopkins, Burgers
becomes
"John Hopkins, Burgers"
</code></pre>

<p>How can I work around this?</p>

<p>This is my code:</p>

<pre><code>ActiveWorkbook.SaveAs ActiveWorkbook.path &amp; "\" &amp; filename,
FileFormat:=xlText, CreateBackup:=False
</code></pre>

<p>Adding this:
I just found out that if I save the file again it removes all "".
Can I add an additional save to the code?</p>