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