Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default Filesearch with disregard of Case

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Filesearch with disregard of Case

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Filesearch with disregard of Case

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AVERAGE - Disregard zero and numbers over 60? Ted[_6_] Excel Worksheet Functions 3 February 13th 10 01:15 AM
disregard earlier post Jenny B. Excel Discussion (Misc queries) 2 March 22nd 07 06:11 PM
Need Help With Formula (Disregard my display name can't change) Need help with sumif Excel Discussion (Misc queries) 1 May 17th 06 02:42 AM
how to disregard the DIV in a range CMAC Excel Worksheet Functions 5 January 20th 05 04:43 AM
Disregard last posting solo Excel Programming 0 February 22nd 04 08:26 PM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"