<p>When one opens an Excel document <code>D:\db\tmp\test1.xlsm</code>:</p>
<ul>
<li></li>
</ul>
<p><code>CurDir()</code> returns <code>C:\Users[username]\Documents</code></p>
<ul>
<li></li>
</ul>
<p><code>ActiveWorkbook.Path</code> returns <code>D:\db\tmp</code></p>
<p>So <code>CurDir()</code> has a system default and can be changed.</p>
<p><code>ActiveWorkbook.Path</code> does not change for the same saved Workbook.</p>
<p>For example, <code>CurDir()</code> changes when you do “File/Save As” command, and select a random directory in the File/Directory selection dialog. Then click on Cancel to skip saving. But <code>CurDir()</code> has already changed to the last selected directory.</p>
<h2><a name="p-34910-add-1" class="anchor" href="#p-34910-add-1" aria-label="Heading link"></a>[ADD]</h2>
<p>Resume VBA for different applications</p>
<p><strong>Access</strong> D:\db\tmp\test1.accdb, like duckboy81 commented:</p>
<ul>
<li>
<p>CurDir() => C:\Users[username]\Documents</p>
</li>
<li>
<p>Application.CurrentProject.Path => D:\db\tmp</p>
</li>
</ul>
<p><strong>Excel</strong> D:\db\tmp\test1.xlsm:</p>
<ul>
<li>
<p>CurDir() => C:\Users[username]\Documents</p>
</li>
<li>
<p>ActiveWorkbook.Path => D:\db\tmp</p>
</li>
<li>
<p>Application.DefaultFilePath => C:\Users[username]\Documents</p>
</li>
</ul>
<p><strong>Outlook</strong>:</p>
<ul>
<li>
<p>CurDir() => C:\WINDOWS\System32</p>
</li>
<li>
<p>Application.Session.Stores(1).Filepath => D:\programdata\Outlook\myOutlookDocX.pst</p>
</li>
</ul>
<p><strong>PowerPoint</strong> D:\db\tmp\test1.ppt:</p>
<ul>
<li>
<p>CurDir() => C:\Users[username]\Documents</p>
</li>
<li>
<p>ActivePresentation.Path => D:\db\tmp</p>
</li>
</ul>
<p><strong>Word</strong> D:\db\tmp\test1.docx:</p>
<ul>
<li>
<p>CurDir() => C:\Users[username]\Documents</p>
</li>
<li>
<p>Application.ActiveDocument.Path => D:\db\tmp</p>
</li>
<li>
<p>Application.ActiveDocument.FullName => D:\db\tmp\test1.docx</p>
</li>
<li>
<p>Application.StartupPath => C:\users[username]\appdata\roaming\microsoft\word\startup</p>
</li>
</ul>
