Using InStrRev if you're using xl2k or above.

Or looping from the last character to the first looking for the path separator
(\ on windows).

AD108 wrote:

What would be the most direct approach to extracting just the last folder
name from "ThisWorkBook.Path".

--

Dave Peterson