Filesearch with disregard of Case

  • Thread starter Thread starter Michael Singmin
  • Start date Start date
M

Michael Singmin

Hello group,

I am using Application.Filsearch to look for text
I want the Filesearch not to look at Case.
So Cat, cAT and caT will be found if .TextOrProperty = "Cat"
I have set .MatchTextExactly = False

But something is still not right because only Cat is found.

Any insights ?

Michael Singmin
 
Michael,
You code functions correctly for me. What is the value of .FoundFiles.Count
that is returned ?

NickHK
 
please note that
matchtextexactly

is NOT releated to the filenames but to the search of filecontents

from help:

MatchTextExactly Property
See Also Applies To Example Specifics
Some of the content in this topic may not be applicable to some
languages.

True if the specified file search will find only files whose body text
or file properties contain the exact word or phrase that you've
specified. Read/write Boolean.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ms excel 2007 Filesearch 2
Using .filesearch for text within a file 1
Equivalent of FileSearch in Access 2007 8
counting xls files in a folder 8
Application . filesearch doesn't work 1
Filesearch Errors 5
Extract folder names only 4
replacement for filesearch in excel 2007 1

Back
Top