Save Excel table in current folder
<p>I want to save my current table as a text file in the same folder as the current workbook (that is open).</p>

<p>I use this code:</p>

<pre><code>ActiveWorkbook.SaveAs ThisWorkbook.path &amp; "\" &amp; filename
</code></pre>

<p>For some reason it save the text file in the same folder as my personal.xlsb.</p>

<p>I use Office 2010</p>

<p>If this is not possible to do easily then maybe one can force Excel to open a browse window where I can pick where I want the file saved.</p>