Thread: Multiple text criteria with FileSearch object?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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 With QuoteReply With Quote