Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add link to specific Excel worksheet in HTML Outlook message | Links and Linking in Excel | |||
How can I link a picture to a particular cell in excel? | Excel Discussion (Misc queries) | |||
Excel to HTML link - and back? | Links and Linking in Excel | |||
How to make an HTML link in excel | Excel Discussion (Misc queries) | |||
Ftp an html file generated by an excel macro | Excel Programming |