title: VBA How to get path to The Current Users Application data folder?
body: <p>In general, </p>
  
  <p>Using VBA, how do I determine where the Current users Application Data folder is?</p>
  
  <p>The FileSystemObjects special folders only knows about 3 folders</p>
  
  <ul>
  <li>WindowsFolder</li>
  <li>SystemFolder</li>
  <li>TemporaryFolder</li>
  </ul>
  
  <p>Specifically, I need a Word Macro to copy a file to the a folder under the Application Data folder. </p>
  
  <p>e.g. In VB.Net I can use <code>My.Computer.FileSystem.SpecialDirectories.CurrentUserApplicationData</code> to do this</p>