Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple text criteria with FileSearch object?
I'm trying to use the FileSearch object to mimic the FileOpenToolsFind in
XL2000. I can get it to do everything except multiple TextOrProperty criteria. These are set by Input Box. It works okay with only one, but won't search for two or more criteria like you can from the dialogue box. I've tried .TextOrProperty = strText1 & strText2 & strText3 .TextOrProperty = strText1, strText2, strText3 but neither works. Any suggestions? Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple text criteria with FileSearch object?
Hi Ed,
Try this modification, .TextOrProperty = strText1 & " or " & strText2 & " or " & strText3 Ed wrote: I'm trying to use the FileSearch object to mimic the FileOpenToolsFind in XL2000. I can get it to do everything except multiple TextOrProperty criteria. These are set by Input Box. It works okay with only one, but won't search for two or more criteria like you can from the dialogue box. I've tried .TextOrProperty = strText1 & strText2 & strText3 .TextOrProperty = strText1, strText2, strText3 but neither works. Any suggestions? Ed -- Cheers Andy http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF with multiple text criteria | Excel Worksheet Functions | |||
Finding text using multiple criteria | Excel Discussion (Misc queries) | |||
SUM with multiple numeric and text criteria | Excel Discussion (Misc queries) | |||
Lookin property of the FileSearch object | New Users to Excel | |||
multiple text criteria sum if function | Excel Worksheet Functions |