Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSearch to find partial words?
I have the following code in a workbook that does a text search through a
folder of Word documents: With Application.FileSearch .NewSearch .LookIn = strLocation .SearchSubFolders = False .TextOrProperty = strSearchFor .MatchAllWordForms = True .Filename = strName & "*.doc" .Execute The code works fine - except it won't find part of a word. For instance, I can't use "brak" (as strSearchFor) to find "brake", "brakes", and "braking". I had hoped the MatchAllWordForms setting would do it, but no such luck. Note: Mswds_en.lex is installed, but I have no idea if it's registered (as per MatchAllWordForms Help topic.) How would I check and rectify in need be? Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
Find partial cell format | Excel Discussion (Misc queries) | |||
FileSearch.Execute does not find *.eml or *.lnk files | Excel Programming | |||
find partial values in cell | Excel Worksheet Functions | |||
FileSearch doesn't find zip files | Excel Programming |