Look in Excel VBA help at the FileSearch object.

--
Regards,
Tom Ogilvy

"The Wonder Thing" wrote in
message ...
Hello Everyone!

I've got an interesting question. I'm wondering if it's possible to write
a macro that can search through a particular directory (and sub-directory)
and match a filename and address path to the contents of a cell. That's all
I need to know, after that I know how to make the cell link to the file, but
I have no idea if the file-searching is even possible with Excel VBA.

It's just getting really annoying browsing for each file seperatly every
time I want to link (I have a lot of entires to link to thier drawing
files). If there's any other way to speed this up, please tell me about that
too.

Thanks!