JScript VBScript Hyperlink not fully working

JeffRasmussen1 — Fri, 20 Apr 2012 11:48:12 GMT

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

Re: JScript VBScript Hyperlink not fully working

AndreaMaffeis — Thu, 08 Nov 2012 09:05:39 GMT

I have the same problem.
Any solution?
Thanks,
Andrea

topic JScript VBScript Hyperlink not fully working in ArcReader Questions

JScript VBScript Hyperlink not fully working

Re: JScript VBScript Hyperlink not fully working