Multiple text criteria with FileSearch object?

[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

 

[Andy Pope]

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

--

Cheers
Andy

http://www.andypope.info