To get rid of some contents from the path location string

hi guys,

i am trying to convey something in the message box..which is as follows:

        ' Promt
        strPrompt = ".xls file location titled 'Test.xls' can be found in location " & filespec & "Test.xls" & "." & vbCrLf & _
        "Please click 'OK' or 'Cancel' to exit this message box."
        
        ' Dialog's Title
        strTitle = "Test.xls Location"
        
        'Display MessageBox
        iRet = MsgBox(strPrompt, vbOK, strTitle)
        
        ' Check pressed button
        If iRet = vbOK Then
            Range("A9").Select
        Else
            ' do nothing
        End If

filespec is "C:\something_else.xls"

so the message pops up as ".xls file location titled 'Test.xls' can be found in location C:\something_else.xlsTest.xls. Please click 'OK' or 'Cancel' to exit this message box." now

i need the message to pop up as ".xls file location titled 'Test.xls' can be found in location C:\Test.xls. Please click 'OK' or 'Cancel' to exit this message box."

i need to get rid of "something_else.xls" from the file location path.

any suggestion guys..

thanks in advance guys..

best regards
plasma33