Image path

**me_king** · 05-28-2012, 01:09 PM

I have an image in excel which i want to use as a hyperlink image. The link is sent to all users through mail. I can send hyperlinks but what I want is that the image to be the hyperlink , something like this :

Please Login or Register  to view this content.

**JosephP** · 05-28-2012, 05:20 PM

if the image isn't stored somewhere everyone can access it I think you'll have to encode the file into base64 and embed that string into the source. you may need to save the file to disk before you can do that.

**me_king** · 05-29-2012, 07:03 AM

Originally Posted by JosephP

if the image isn't stored somewhere everyone can access it I think you'll have to encode the file into base64 and embed that string into the source. you may need to save the file to disk before you can do that.

I just want to insert the image into the html tag mentioned above. I tried using names but i think html tags cant read that so i have to specify the path of that image..

**JosephP** · 05-29-2012, 10:17 AM

the image does not have a path unless you extract it from the container file (if it's an openxml format file) and specifying a local path won't help since nobody else will be able to access it.

**me_king** · 05-29-2012, 06:42 PM

Originally Posted by JosephP

the image does not have a path unless you extract it from the container file (if it's an openxml format file) and specifying a local path won't help since nobody else will be able to access it.

So is there any way i can specify the img src tag in html to take the image in excel. Actually I am sending the link of a file path to all users through outlook... and its automated. So for the body of the outlook i have that html coding.... Earlier i used to simply sent the hyperlink but now i want the image to be the hyperlink. Could it be done...

**JosephP** · 05-30-2012, 05:03 AM

you can write the file to disk then encode it and embed that data using code like this

Please Login or Register  to view this content.

which you call with this

Please Login or Register  to view this content.

as an example.

**me_king** · 05-30-2012, 08:53 PM

Originally Posted by JosephP

you can write the file to disk then encode it and embed that data using code like this

Please Login or Register  to view this content.

which you call with this

Please Login or Register  to view this content.

as an example.

Appreciate your time and effort...will let you know how it goes....

**me_king** · 05-31-2012, 06:35 AM

Originally Posted by me_king

Appreciate your time and effort...will let you know how it goes....

Image but with an "x" i mean invalid image, the file gets saved and i have checked the path is also correct. Don't know for some reason its not showing the image.

**me_king** · 05-31-2012, 06:52 AM

Originally Posted by me_king

Image but with an "x" i mean invalid image, the file gets saved and i have checked the path is also correct. Don't know for some reason its not showing the image.

Yes it worked but what I did is that I saved the image and then used the same path to refer to it, used piccode function and removed the other ones...

**JosephP** · 05-31-2012, 06:56 AM

since I don't know what you were doing with the output I can't comment. I tested the code by pasting the output into an htm file and that loaded the image perfectly in IE.