how to create hyper links



1
How do I create a Hyperlink to open specific worksheet, within the excel workbook that I am working on?
Ex: If i click the text on my excel sheet saying, "Please refer to Sheet 2", i want it to link to Sheet 2 of my work book

3 Answer(s)


0

If you are still looking for the answer on this one, ESRI Support helped me write a hyperlink VB script for this. It is working well as long as I include the full path to the Excel table. Still need to figure out why it is not working with relative path.

Copy/paste the text below into the hyperlink script window in your layer properties. Make sure you have two text fields in your attribute table, "Workbook" contains the path and name of the spreadsheet.xls and "Sheet" contains the name of the specific worksheet.

0

If you are still looking for the answer on this one, ESRI Support helped me write a hyperlink VB script for this. It is working well as long as I include the full path to the Excel table. Still need to figure out why it is not working with relative path.

Copy/paste the text below into the hyperlink script window in your layer properties. Make sure you have two text fields in your attribute table, "Workbook" contains the path and name of the spreadsheet.xls and "Sheet" contains the name of the specific worksheet.

0

If you are still looking for the answer on this one, ESRI Support helped me write a hyperlink VB script for this. It is working well as long as I include the full path to the Excel table. Still need to figure out why it is not working with relative path.

Copy/paste the text below into the hyperlink script window in your layer properties. Make sure you have two text fields in your attribute table, "Workbook" contains the path and name of the spreadsheet.xls and "Sheet" contains the name of the specific worksheet.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password