I've been searching around hoping to find a progressive searching method, but with no luck.
What I am interested in is if there is a more progressive search method then a For Next loop?

For example, lets say I listed all the files on my C drive. To search for a file I do a For Next loop through the list and compare my filename to the data in the list. And that is ok if you want just that one pass.
But what happens if I have to search for a 100 or more file names? The number of passes becomes 100 * ListCount and that gets pretty slow.

Anyone have or heard of any other (faster) methodologies?