title: Get the current directory from VBA
body: <p>in VBA there is a <code>ChDir</code> function that allows to set/change the current directory.<br>
  That Current Directory is also affected by a user browsing through his drives/folders from Access (or Excel), even if he clicks Cancel in the end without opening anything.<br>
  My question is: in the later case, how do I retrieve the Current Directory ?</p>
  
  <p>Note: the CurrentDirectory has <strong>nothing</strong> to do with the folder of the CurrentDb!  </p>