Automatic Hyperlinking?
 

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!

Automatic Hyperlinking?
 

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!

Automatic Hyperlinking?
 

Hey, thanks for your quick reply. Awesome Stuff!