Function GetFileTitle(ByVal FileName As String) As String
Dim i As Long
i = InStrRev(FileName, "\")
If i Then FileName = Right(FileName, Len(FileName) - i)
i = InStrRev(FileName, ".")
If i Then FileName = Left(FileName, i - 1)
GetFileTitle = FileName
End Function
' ==== Utilisation :
' Debug.Print GetFileTitle("C:\windows\calc.exe")
'