Hyperlink to Embed Object

Is there anyway to have a list of hyperlinks to file locations and be
able to click on the hyperlink which opens the embedded object. I
need to be able to do this with a list of file names. I found a macro
that will embed an image object on a list of file names inside the
comment box which then allows the mouseover function to work but I
have multipage TIFFs that I want to embed. The best way for this to
work is have a list of file names and run a macro that auto adds the
images to the excel spreadsheet and generates hyperlinks to these.
Hopefully this is making sense.

Brent

Hi Brent,
Assume what you found was
Insert Selected Picture Into Comment
http://www.contextures.com/xlcomments03.html#Picture

I'm not clear on what you want, it seems you just want to
hyperlink to the picture, in which case such pictures need
not reside in Excel. If that is the case it will keep your
Excel file a lot smaller (meaning it won't make it so huge).
So you would simply link to the pictures as if they were
HTML files and let the system recognize the application
to be used to open your TIFF files based on their filetype
extension.

If file is on your system
A1: Beautiful Sunset
B1: =HYPERLINK(C1,"view")
C1: c:\mypictures\img304.tif

or you can use concatenation
A1: Beautiful Sunset
B1: =HYPERLINK("c:\mypictures\img" & C1 &".tif","view")
C1: 304

similar code for files on the web

If this is for something like a slide show that you might want
to generate an HTML file using Excel.
http://www.mvps.org/dmcritchie/excel/xl2html.htm
which helps you create a table to add to your own HTML.

Or many photo software applications can generate HTML.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"brent" wrote in message ups.com...
Is there anyway to have a list of hyperlinks to file locations and be
able to click on the hyperlink which opens the embedded object. I
need to be able to do this with a list of file names. I found a macro
that will embed an image object on a list of file names inside the
comment box which then allows the mouseover function to work but I
have multipage TIFFs that I want to embed. The best way for this to
work is have a list of file names and run a macro that auto adds the
images to the excel spreadsheet and generates hyperlinks to these.
Hopefully this is making sense.

Brent