Sorry about not getting back to you sooner. I can't find the link I had
located when I first answered you, but if you do a Google search using
this..

excel 2007 filesearch

or this...

excel 2007 filesearch replacement

you will find, one, that the FileSearch object has been removed from the
Office 2007 product line and, two, several links containing replacement
options for it. This is how Microsoft handles it...

http://support.microsoft.com/kb/920229

look at the WORKAROUND section for the link to their coded solution.

--
Rick (MVP - Excel)


"J_Knowles" wrote in message
...
Thanks for the reply. I was not the OP, but was an interested reader in
the
code. Could you provide the links to the newsproups about alternatives to
FileSearch when using 2007.

Thanks,
--
Data Hog


"Rick Rothstein" wrote:

You have now discovered why you should *always* tell us what version of
Excel you are using when you ask a question on these newsgroups...
FileSearch was removed from Excel 2007. Here is a forum link that has
some
alternatives shown as links within the discussions... take your pick for
a
replacement.

--
Rick (MVP - Excel)