Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Michael,
You code functions correctly for me. What is the value of .FoundFiles.Count that is returned ? NickHK "Michael Singmin" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 Michael Singmin wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AVERAGE - Disregard zero and numbers over 60? | Excel Worksheet Functions | |||
disregard earlier post | Excel Discussion (Misc queries) | |||
Need Help With Formula (Disregard my display name can't change) | Excel Discussion (Misc queries) | |||
how to disregard the DIV in a range | Excel Worksheet Functions | |||
Disregard last posting | Excel Programming |