Vba extract filename from path

Function GetFilenameFromPath(ByVal strPath As String) As String
    If Right$(strPath, 1) <> "\" And Len(strPath) > 0 Then
        GetFilenameFromPath = GetFilenameFromPath(Left$(strPath, _
        	Len(strPath) - 1)) + Right$(strPath, 1)
    End If
End Function

Source: stackoverflow.com

Similar codes

8 votes180 views1 answer
Run command pormpt in background windows
VBA
0 vote170 views1 answer
Xlbycolumns is not declared
VBA
0 vote189 views1 answer
Vba sheet hide unhide
VBA
0 vote153 views1 answer
Excel vba open browser
VBA
1 vote182 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
6 votes177 views1 answer
Excel vba isalpha
VBA
0 vote180 views1 answer
Rotate image by any angle vb.net
VBA
1 vote167 views1 answer
Excel vba unload userform
VBA
0 vote181 views1 answer
Excel vba delete folder
VBA
5 votes185 views1 answer
Xl vba double quotes in string literal
VBA