How to get name of the last folder from the path

[ThrottleWorks]

Hi,

I need to derive name of last folder from the path.
For example, path is ‘\\aa\aa\aa\aa\aa\Last folder’
Result in this case will be Last folder.
How do I get it. Can anyone please help me in this.

 

[Marc L]

Hi !

Just using InStrRev & Right (or Mid) functions, at beginner level …​

 

[shrivallabha]

Untested:

strinput = "\\aa\aa\aa\aa\aa\Last folder"
strlastf = Split(strinput, Application.PathSeparator)(UBound(Split(strinput, Application.PathSeparator)))
MsgBox strlastf

 

[ThrottleWorks]

Hi @Marc L sir, thanks a lot for the help. Have a nice day ahead.

Hi @shrivallabha , thanks a lot for the help. It is working perfect. Good night.