Hi All,
In ArcMap I have a hyperlink function that essentially reads a link and an ID from a feature, then opens an excel spreadsheet (link) and then goes to an exact row in that spreadsheet (ID). Works great on my computer from ArcMap. When I publish it and a user opens it on their computer with ArcReader, it opens the spreadsheet but does not continue with the second part of going to the exact row from the ID. Is this an issue with something on the user's computer? Is this something ArcReader simply won't/can't do? Any help would be greatly appreciated!
Here is the function:
Function OpenLink ( [Link], [UId] )
Dim path
Dim rownum
Dim objShell
path = [Link]
rownum = [UId]
Set xl = CreateObject("Excel.application")
xl.Application.Workbooks.Open path
xl.Application.Visible = True
xl.Application.ActiveSheet.Cells(rownum, 1).Select
Set xl = Nothing
End Function
