Hi Tom,

I used the solution send in by tinyjack before you send in your solution.
When I psot my reply I did not notice that you had send another solution to.
From you I understand that MatchTextExactly = True has nothing to do with
filename, but still it is strange to me that if I ask for Filename =
"up12_7.txt" the filename "up12_70.txt" is also included. I'm afraid that
I'm not the only one that thinks like that and get an error because of this.

Anyway thanks for your solution and support. I see your name very often and
learned also a lot from your answers on question from other users.

Best regards,
Gerrit


"Tom Ogilvy" wrote in message
...
Even after I explained it to you? What part don't you understand?

--
Regards,
Tom Ogilvy

"Gerritvans " wrote in message
...
tinyjack wrote:
I would not use the FileSearch object to do this, you can just use
the Dir function:


Code:
--------------------

Sub test()

Dim strFound As String

strFound = Dir(Interaction.Environ$("userprofile") & "\My
Documents\Test files\up12_7.txt")

If Len(strFound) 0 Then
MsgBox "File found"
Else
MsgBox "File NOT found."
End If

End Sub

--------------------


HTH

TJ

Thanks TJ, your solution is working fine. But I still not understand
what was wrong with my solution...

Gerrit


---
Message posted from http://www.ExcelForum.com/