Extract Directory Name from FullPath


Function FullPath_FileName(ByVal strFullPath As String) As String
'With '\' at end
?FullPath_FileName("c:\x.txt")		>> c:\
?FullPath_FileName("c:\x\y.txt")	>> c:\x\
?FullPath_FileName("x.txt")			>> '' (empty string)
    FullPath_FileName = Left(strFullPath, InStrRev(strFullPath, "\"))
End Function