Excel hyperlink

[Andrew Mongeon]

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?

[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

[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

[Andrew Mongeon]

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
>
>