Home » Blogs » Nick's blog

XLA routines: EE_FileNameFromFilePath

Nick's picture
Submitted by Nick on 25 January, 2015 - 18:04
Returns the file name from the file path 
Function EE_FileNameFromFilePath(strFilePath As String) As String
'http://excelexperts.com/xla-routines-eeFileNameFromFilePath

    EE_FileNameFromFilePath = Mid(strFilePath, InStrRev(strFilePath, Application.PathSeparator) + 1)
End Function
»