vba-tutorial.com
Parsing a File String Into Path, File Name, and Extension - VBA Tutorial
Parse a File Path into Folder, File and Extension using VBA string manipulation.