Parse File Path to get File Name with extension

[kpark91]

Hello,
as the title suggests I need to parse a string of file path in order to get a filename including the extension.

For example, If I have
C:\Users\Blarg\Desktop\Hello.txt

I ony need Hello.txt through a VBA code.


I could find this but from answering similar questions on this board, I remember a suggestion from someone that I can find "\" from the end of the string which meant that I didn't need to loop through the string in order to achieve this.

It was something like FindRev but I can't seem to find the function.

So, what was this function?

Thank you in advance,
KPark.

 

[RoryA]

Mid(path,instrrev(path,"\")+1)

 

[kpark91]

Awesome. Works perfectly.

Thank you.