A
Andy Dorph
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
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