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

4 votes227 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote215 views1 answer
Vba line feed
VBA
1 vote230 views1 answer
Extract the second word in a text in excel
VBA
0 vote218 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote213 views2 answers
Excel vba prevent save
VBA
1 vote214 views1 answer
Excel vba first row in range
VBA
0 vote232 views1 answer
Get month number from month name vbnet
VBA
1 vote244 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
20 votes294 views1 answer
Excel vba factorial
VBA
0 vote226 views1 answer
Search in richtextbox vb.net
VBA