Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem: FileSearch .TextOrProperty WIth Phrase Containing Blanks
The following code will return files containing the phrase: Chris Ate
His Big Lunch which I do not want. I want to get files containing only the phrase "Chris Ate His Lunch" With Application.FileSearch .NewSearch .LookIn = Folder .SearchSubFolders = False .TextOrProperty = "Chris Ate His Lunch" .filename = "*.txt*" .MatchTextExactly = True .Execute For file_no = 1 To .FoundFiles.Count Debug.Print .FoundFiles(file_no) Next End With Thank you, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filesearch problem | Excel Programming | |||
FileSearch for a TextorProperty with a wildcard | Excel Programming | |||
FileSearch Problem | Excel Programming | |||
FileSearch Problem | Excel Programming | |||
FileSearch Problem | Excel Programming |