View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sam Hodo Sam Hodo is offline
external usenet poster
 
Posts: 13
Default added characters

This did not help. I am still getting the extra "mystring"
I am doing an exact search.


"JLGWhiz" wrote:

"MatchAllWordForms = True" if you seach for "no" will give you "no", "not",
"now", "nowhwere", etc. So if you want only the exact word you have to make
it "MatchAllWordForms = False"

"Sam Hodo" wrote:

Hello;

When I am doing a search..

With Application.FileSearch
.NewSearch
.LookIn = DDIR
.SearchSubFolders = False
.Filename = DDIR
.TextOrProperty = MyString
.MatchAllWordForms = True
.FileType = msoFileTypeAllFiles

I am getting extra characters added to the search string..

input lines are
ACCESS CLOSE
ACCESS OPEN

mystring lines are
"ACCESS CLOSE"
"ACCESS OPEN"

I do not need the search string adding characters...

Can someone help ...

Thanks for your time and efforts..
Sammy