Posts by 456

Jup. I was wondering why in n2 the word exactly stood. I didn't saw it in the popdown list just under the first textfield.
Later i noticed that there was an extra match field!

But at this moment, i already found the problem: You was working with FileSearch.Filename = "*.txt". But my documents are all *.doc. In my own code, i allready had *.doc, so thats why it was working with me (with the extra quotes)
BTW, i didn't REALLY test it, but the results are the same, if i set 'exactly' or not
Tnx andy!
[bit offtopic]
Now i want to load this function in its memory every time excel starts. is that possible (like =sum, or =if etc)? Or do i have to run the module, where the function is in, in a excel sheet.
[/bit offtopic]

I have to cry a little... This is it! Those quatriple quotes!
I have to say that you code did not work, but i wrote a function, where your code was the basis of:

Option Explicit


Function searchin(trainnumber As String, carnumber As String) As Integer
    Dim search_dir As String
    Dim searchFor As String
    Dim strQuote As String
    strQuote = """"


    search_dir = "c:\its456\Dick\" 
    searchFor= strQuote & trainnumber & "/" & carnumber & strQuote
    
    With Application.FileSearch
        .NewSearch
        .LookIn =seacrh_dir
        .SearchSubFolders = False
        .MatchTextExactly = True
        .TextOrProperty = searchFor
        .Filename = "*.doc"
        .Execute
        searchin = .FoundFiles.Count
    End With
End Function

But this works. It only find the correct string, like '1111/2222' which is an unique number!
Thanx man! (it is soooooooo simple after all )

[solved]

Hi Andy,

Thanks for the attached file! At this moment i have EXACTLY the same problem
B U T:
It doesn't work quite well for me.
Because the macro returns a result as well, while there isn't a founded string! I am absolutely sure about that.
e.g.
I'd like to use this function from windows:
http://stuwww.uvt.nl/~s990868/untitled1.jpg

Now i would like to find the combination of: "9316/4538" in some *.doc files.
Windows will return a file which is shown at arrow 2. Your macro does the same. So far so good.
But the combination "9316/4539" is
NOT in the document. Via the function as shown above, windows will not return 1 file. BUT your code will do it! Your code will return the same document as shown above. Weird or not?
Do you know what i do wrong?
(does this function not accomodate my problem?)
Tnx!

EDIT:
I see what the problem is/can be. The sign '/' is seen as 'and'.
What i like to search is the string '1234/5678' EXACTLY. so WITH the '/' sign.
At this moment, he is searching for 1234, and if it is found, he will search for the next string, 5678 somewhere else in the document.
Any idea how i can put the search string litterally in .TextOrProperty?
tnx anyway