title: How to get the name of the parent folder from a file path?
body: <p>Using VBA, is it possible to get the name of the folder that contains a file?</p>
  
  <p>Input: <code>C:\Windows\System32\notepad.exe</code></p>
  
  <p>Output: <code>System32</code></p>