Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / February 2007

Tip: Looking for answers? Try searching our database.

Hyperlink to Embed Object

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brent - 19 Feb 2007 14:59 GMT
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
David McRitchie - 20 Feb 2007 16:02 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.