Multiple text criteria with FileSearch object?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I'm trying to use the FileSearch object to mimic the File>Open>Tools>Find 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
 
Hi Ed,

Try this modification,

.TextOrProperty = strText1 & " or " & strText2 & " or " & strText3
I'm trying to use the FileSearch object to mimic the File>Open>Tools>Find 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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top