How to save as with VBA in current location
<p>I'm currently saving my excel file with this command:</p>

<pre><code> ActiveWorkbook.SaveAs Filename:="pleasework", FileFormat:=52
</code></pre>

<p><em>But</em> when it saves it, it saves it in documents. </p>

<p>I want to save it in the current location of the macro (of the file, where it's activated).<br>
Any advice? Changing it to:</p>

<pre><code>Filename:="C:/pleasework"
</code></pre>

<p>Won't work...</p>

<p><strong>Thanks</strong>!</p>