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

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