title: Save Excel table in current folder
body: <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>