Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filesearch problem agabrieli Excel Programming 1 January 24th 06 12:31 PM
FileSearch for a TextorProperty with a wildcard myensr Excel Programming 1 December 10th 03 09:49 AM
FileSearch Problem Jarek[_3_] Excel Programming 3 November 27th 03 02:06 PM
FileSearch Problem Nigel[_4_] Excel Programming 4 October 11th 03 03:43 PM
FileSearch Problem Bin[_2_] Excel Programming 6 August 2nd 03 02:04 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"