title: VBA: How to get the local filepath of a workbook that uses the new autosave feature (and thus is technically opened from OneDrive)?
body: <p>I have a workbook that does some analysis and outputs its results to a textfile in the same directory as the workbook is saved. I need to run this code on multiple computers so the local directory changes. Previously I just used </p>
  
  <pre><code>Application.ActiveWorkbook.Path
  </code></pre>
  
  <p>but since the autosave feature was enabled (which is useful, so I want to continue using) this returns the remote filepath in OneDrive.</p>
  
  <p>How can I get the local filepath?</p>