ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hyperlink for the Office-2003 Excel web component (https://www.excelbanter.com/excel-programming/349130-hyperlink-office-2003-excel-web-component.html)

ilyam

hyperlink for the Office-2003 Excel web component
 
According to the data posted on Msdn, Hyperlink address is a path to a
destination such as an object, document, or Web page.
A hyperlink address can be a URL (address to an Internet or intranet
site) or a
UNC network path (address to a file on a local area network).
A hyperlink address may also contain more specific address information
(for example, a database object, Microsoft Word bookmark, or Microsoft
Excel
cell range that the address points to).
When you click a hyperlink, your Web browser or Microsoft Access uses
the hyperlink
address to go to the specified destination.

I have created 2 Excel(Office 2003) Spreadsheet Web components in
aTest.htm file( of course with different id's )
and I am trying to "jump" from one cell of the first object to some
sell of the second
one using Hyperlink address as a path - does not work!

Failed Example of using the Hyperlink address to "jump" to another cell
inside the same Excel(Office 2003) Spreadsheet Web component:
<html
....
....
<script LANGUAGE="VBScript"
Dim aHyperlinkObj = Test1Hyperlink2003_Spreadsheet.Range("A3")
aHyperlinkObj.Value = "GoTo C3 in the same object"
aHyperlinkObj.Hyperlink.Address = "#" +
aHyperlinkObj.ActiveSheet.Name + "!C3"
</script
</html

Failed Example of using the Hyperlink address to "jump" to a second
Excel(Office 2003) Spreadsheet Web component:

<html
....
....
<script LANGUAGE="VBScript"
Dim aHyperlinkObj = Test1_2003_Spreadsheet.Range("A3")
aHyperlinkObj.Value = "GoTo C3 in the second object"
aHyperlinkObj.Hyperlink.Address = "#" +
Test2_2003_Spreadsheet.ActiveSheet.Name + "!C3"
</script
</html
I am looking for a right way to implement this hyperlink for the
Office-2003 Excel web component?

Thanks.

Ilyaam



All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com