Automatic Hyperlinking?

[Guest]

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!

 

[Tom Ogilvy]

Look in Excel VBA help at the FileSearch object.

--
Regards,
Tom Ogilvy

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.

 

[Guest]

Hey, thanks for your quick reply. Awesome Stuff!