ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Are multiple filesearch objects allowed? (https://www.excelbanter.com/excel-programming/278248-multiple-filesearch-objects-allowed.html)

Philip Davich

Are multiple filesearch objects allowed?
 
Is it possible to run to filesearch objects at the same
time? I tried a filesearch within a filesearch, using
a "for i = 1 to .FoundFiles.Count" on the first
filesearch, and "for j = 1 to .FoundFiles.Count" for the
second filesearch. The first pass through both
filesearches works fine, but when the procedure loops
back for i = 2, the criteria for the second filesearch
are applied instead of those for the first. I even gave
the two filesearch objects different names, but it
doesn't help. Is what I want to do even possible?

Dick Kusleika

Are multiple filesearch objects allowed?
 
Philip

I seem to remember that you can only have one search going at a time. I
can't seem to find anything to back that up, but that's what I remember.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Philip Davich" wrote in message
...
Is it possible to run to filesearch objects at the same
time? I tried a filesearch within a filesearch, using
a "for i = 1 to .FoundFiles.Count" on the first
filesearch, and "for j = 1 to .FoundFiles.Count" for the
second filesearch. The first pass through both
filesearches works fine, but when the procedure loops
back for i = 2, the criteria for the second filesearch
are applied instead of those for the first. I even gave
the two filesearch objects different names, but it
doesn't help. Is what I want to do even possible?





All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com