InStrRev begins searching at the end of a string and returns the position where one string is found within another string:
Sub InstrRevExample() Debug.Print InStrRev("c:\my documents\my file.txt", "\") End Sub