| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office Project vs. Office Web Component | Excel Worksheet Functions | |||
| How do I display the full file path for a hyperlink in Office 2003 | Excel Discussion (Misc queries) | |||
| Office 2003 Chart Web Component | Excel Programming | |||
| Office Chart Component and Excel | Excel Programming | |||
| Following a custom protocol hyperlink causes a warning in Excel (Office) 2003 | Excel Programming | |||
Threaded Mode
