Excel hyperlink
 

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?

Excel hyperlink
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=521696

Excel hyperlink
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=521696

Excel hyperlink
 

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.

"Dav" wrote:


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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=521696