Sub a()
Debug.Print nstrGetFileName("c:\AA.pdf")
End Sub
Private Function nstrGetFileName(ByVal pstrFilenName As String) As String
Dim strFileName As String
Dim intInstrRev As Integer
Dim intInstrRevExtension As Integer
strFileName = pstrFilenName
intInstrRev = InStrRev(strFileName, "\")
If intInstrRev > 0 Then
strFileName = Mid(strFileName, intInstrRev + 1)
Else
strFileName = strFileName
End If
intInstrRevExtension = InStrRev(strFileName, ".")
If intInstrRevExtension > 0 Then
strFileName = Left(strFileName, intInstrRevExtension - 1)
Else
strFileName = strFileName
End If
nstrGetFileName = strFileName
End Function