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!