| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
added characters
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
added characters
"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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
| Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
| All keyboard characters and symbols shold be added in Autoshapes | Excel Discussion (Misc queries) | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Linear Mode
