ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   picture as link in Excel generated html (https://www.excelbanter.com/excel-programming/329243-picture-link-excel-generated-html.html)

Andy Dorph

picture as link in Excel generated html
 
In reviewing the html code generated by Excel, I noted the following tag
created for a picture I placed in a spreadsheet:

</v:shapetype<v:shape id="_x0000_s1027" type="#_x0000_t75"
style='position:absolute;
margin-left:0;margin-top:0;width:24.75pt;height:23.25pt;z-index:3'
<v:imagedata src="05Q3_files/image001.gif" o:title="excelicon"/

I am dynamically adding the picture through VBA as part of a macro that
loops through 93 woksheets in a workbook and saves each sheet as a separate
workbook.

Is there any way I can program the spreadsheet/cell/image to convert the
image to an anchor tag (<a href</a) like the lines below?

<a href=link location
<v:imagedata src="05Q3_files/image001.gif" o:title="excelicon"/
</a

Thanks in advance



All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com