Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day")

ChristopherL

Guest

Posts: n/a

30th Sep 2008

Hello,

I cannot seem to be able to use FileSearch to find files containing
"An apple a day" without also retrieving files containing "An orange
apple a day". What are my alternatives to be able to do this fast?

This is what my code looks like:

With Application.FileSearch
.NewSearch
.LookIn = Folder
.SearchSubFolders = False
.TextOrProperty = "An apple a day"
.filename = "*.txt*"
.MatchTextExactly = True

.Execute

Msgbox .FoundFiles.Count

End With

Thanks for any suggestions,
Chris

« Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day") | excel formula question »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day")	ChristopherL	Microsoft Excel Programming	0	30th Sep 2008 09:14 PM
Problem: FileSearch .TextOrProperty WIth Phrase Containing Blanks	ChristopherL	Microsoft Excel Programming	0	30th Sep 2008 04:28 PM
Can I write something like: If MyString In ("Apple", "Orange", "Pear") Then...	Ronald S. Cook	Microsoft VB .NET	9	5th Aug 2007 08:12 PM
Apple II Dos - Apple II " The DOS Manual - Disk Operating System " PDF format	bigbluesigns@gmail.com	Freeware	3	15th Jun 2006 11:33 PM
FileSearch for a TextorProperty with a wildcard	=?Utf-8?B?bXllbnNy?=	Microsoft Excel Programming	1	10th Dec 2003 09:49 AM