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
|