• Home
 · 
• String Manipulation
 · 
• Two lines of code to extract the file name from a full file path.

Two lines of code to extract the file name from a full file path.

Two lines of code to extract the file name from a full file path.

Rate Two lines of code to extract the file name from a full file path.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    Dim sFpath() As String
    
    sFpath = Split(sPath, "\")
    GetFileName = sFpath(UBound(sFpath()))
   
End Function

Private Sub Command1_Click()
Dim s As String
    s = GetFileName("c:\ABC\Test.mdb")
    MsgBox s
End Sub