View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ChristopherL ChristopherL is offline
external usenet poster
 
Posts: 18
Default Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day")

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