Excel hyperlink

G

Guest

Problem with hyperlinking multiple files. I have to link the information in
each row of the spreadsheet to its associated picture. Is there a way to do
that other than right clicking and adding a hyperlink in each cell since the
spreadsheets have 100+ entries? Some way to tell Excel to link to a folder
and just drag the file hyperlinks through the whole worksheet?
 
D

Dav

Yes look at the hyperlink function.
If your filenames are contained in say c3, try "C:\test\"&c3 and see if
this gives you the path you require. Obviously you need the appropriate
path, if it looks ok try hyperlink("C:\test\"&c3). You can then copy it
down

Regards

Dav
 
D

Dav

You can also insert the picture into the appropriate row in the
spreadsheet, Dave Peterson did the following for me a few months ago.
If you adjust the macro accordingly it inserts the picture in the cell
to the right of the column containing its name, and repeats for the
whole file to the bottom

http://www.excelforum.com/showthread.php?t=480860

Regards

Dav
 
G

Guest

I think that the macro you linked me to might do the trick. I've only messed
around with it for a little bit, but I think part of the problem may be that
I don't need to reference pictures in multiple colums. I only need to
hyperlink one image to one row. For example C:\My
Pictures\Pics\Image_001.jpg. Except there are 100+ rows and images. I'm not
familiar enough with macros to modify the one I have now to hyperlink to that
directory and automatically move on to image #2 once image #1 has been used.
I appreciate all your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top