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
> 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
[quoted text clipped - 7 lines]
>
> Brent