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

C

ChristopherL

Hello,

I cannot seem to be able to use FileSearch to find files containing
"An apple a day" without also retrieving files containing "A big red
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
 

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

Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day") 0
Problem: FileSearch .TextOrProperty WIth Phrase Containing Blanks 0
ms excel 2007 Filesearch 2
Filesearch Errors 5
using application.filesearch for searching text in PDF 2
counting xls files in a folder 8
Seach Find txt file or close workbook in workbook_open() 1
Problem with Filesearch in Excel 2007 1

Top