I'm trying to link from a web page to a range in an excel workbook. This works fine in XP home edition with excel 2002. No fuss, no muss:
When I try the same html file in XP professional, it opens the file but ignores the sheet & range, opening it to wherever it was saved (that sheet and active cell).
Q1: Any idea why it's not working in XP professional?
Q2: Any workarounds? I can put the sheet!range info on the clipboard from the web page side, but when I get over to Excel (via the hyperlink) I can't think of any event that will be triggered after the first time when the workbook is opened (I'd use the event to grab the info from the clipboard and activate the intended sheet and range). i.e., the user will likely hyperlink back from the workbook to the web page and back to the workbook several times while browsing thru the info (it starts out at a very high level on the web page and gets more specific on sheets in the workbook).
Another thought was to use hyperlink parameters, but again, what event handler would allow me to grab the parameters and use them on the way back into the workbook?
It also works fine from ppt to xls and back on both operating systems, but there's a need to do it from the web page directly.
-Argh2
Code:
<html>
<a href="test1.xls#Sheet1!B2">go</a>
</html>When I try the same html file in XP professional, it opens the file but ignores the sheet & range, opening it to wherever it was saved (that sheet and active cell).
Q1: Any idea why it's not working in XP professional?
Q2: Any workarounds? I can put the sheet!range info on the clipboard from the web page side, but when I get over to Excel (via the hyperlink) I can't think of any event that will be triggered after the first time when the workbook is opened (I'd use the event to grab the info from the clipboard and activate the intended sheet and range). i.e., the user will likely hyperlink back from the workbook to the web page and back to the workbook several times while browsing thru the info (it starts out at a very high level on the web page and gets more specific on sheets in the workbook).
Another thought was to use hyperlink parameters, but again, what event handler would allow me to grab the parameters and use them on the way back into the workbook?
It also works fine from ppt to xls and back on both operating systems, but there's a need to do it from the web page directly.
-Argh2
