How to get the name of the parent folder from a file path?
<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>