Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day") | Excel Programming | |||
Problem: FileSearch .TextOrProperty WIth Phrase Containing Blanks | Excel Programming | |||
Alternatives to "WorksheetFunction.VLookup" | Excel Programming | |||
How to turn on the pop-up "alternatives" while editing in the VBA Editor | Excel Programming | |||
FileSearch for a TextorProperty with a wildcard | Excel Programming |