ArcadeStickMonk
Member
Short Version:
I need hyperlinks in a XML or XLS document to open in frame contained on the same page displaying the XML\XLS document.
Long version:
I have a XLS sheet containing around 1100 rows. Each one of these rows is primarily identified by an item number. For each of these items, I have an image. I want the item numbers themselves to be hyperlinks to the pictures, but want the spreadsheet to remain visable and usable while the image is displayed.
I'm only average at Excell, so if there is a way to do this entirely inside Excell, I do not know of it. I do know how to do some HTML, and so thought that hosting the XLS sheet inside a HTML page would be a quick fix because I could use frames to create a "window" where the hyperlink could blast the image out to.
This is complicated, however, by the fact that while Word will left you assign target frames in it's hyperlink wizard, Excell will not. Furthermore, I converted the XLS to XML and found the first item. I inserted corret HTML code for assigning a target frame in what should be the correct place. However when the XML is opened inside the HTML page, the frame assignment is ignored and the image is opened up in the same frame as the XLS.
If anyone knows how to correctly implement frame-targeted hyperlinks in Excell, or has another solution using HTML, Excell, or Word, you could make my day a lot easier and I would be grateful.
Thanks to any who read this.
I need hyperlinks in a XML or XLS document to open in frame contained on the same page displaying the XML\XLS document.
Long version:
I have a XLS sheet containing around 1100 rows. Each one of these rows is primarily identified by an item number. For each of these items, I have an image. I want the item numbers themselves to be hyperlinks to the pictures, but want the spreadsheet to remain visable and usable while the image is displayed.
I'm only average at Excell, so if there is a way to do this entirely inside Excell, I do not know of it. I do know how to do some HTML, and so thought that hosting the XLS sheet inside a HTML page would be a quick fix because I could use frames to create a "window" where the hyperlink could blast the image out to.
This is complicated, however, by the fact that while Word will left you assign target frames in it's hyperlink wizard, Excell will not. Furthermore, I converted the XLS to XML and found the first item. I inserted corret HTML code for assigning a target frame in what should be the correct place. However when the XML is opened inside the HTML page, the frame assignment is ignored and the image is opened up in the same frame as the XLS.
If anyone knows how to correctly implement frame-targeted hyperlinks in Excell, or has another solution using HTML, Excell, or Word, you could make my day a lot easier and I would be grateful.
Thanks to any who read this.