file search in subfolders

Does anyone have a good bit of code to effectively search through a
designated folder and its subfolders? I have used code to search just one
folder, but I can't figure out how to incorporate all subfolders and their
subfolders. I have tried .Lookin, and that is unreliable.

Thanks for your suggestions.

I also want to be able to search by filesize (> 100 MB) and by date last
accessed (before a month ago). I am having some problems quickly obtaining
those values.

"Pflugs" wrote:

> Does anyone have a good bit of code to effectively search through a
> designated folder and its subfolders? I have used code to search just one
> folder, but I can't figure out how to incorporate all subfolders and their
> subfolders. I have tried .Lookin, and that is unreliable.
>
> Thanks for your suggestions.

Pflugs,
I would advise against the .FileSearch function that comes with Office, as
many people report flaky results in all versions & apps.
Use VB intrinsic functions:
http://vb.mvps.org/samples/project.asp?id=DirDrill

You can add your own checks for FileLen and FileDateTime on each file.

There are other ways of achieving you aim but this will get you started.

NickHK

"Pflugs" <Pflugs@discussions.microsoft.com> wrote in message
news:89FA336C-0C0B-40AF-B264-5C94C9EE5F99@microsoft.com...
> I also want to be able to search by filesize (> 100 MB) and by date last
> accessed (before a month ago). I am having some problems quickly
obtaining
> those values.
>
> "Pflugs" wrote:
>
> > Does anyone have a good bit of code to effectively search through a
> > designated folder and its subfolders? I have used code to search just
one
> > folder, but I can't figure out how to incorporate all subfolders and
their
> > subfolders. I have tried .Lookin, and that is unreliable.
> >
> > Thanks for your suggestions.