JimS
11-12-2009, 07:25 AM
Below is a routine that opens a Hyperlink based on the user’s selection, this works as designed.
Is there a way to verify that the Hyperlink was successfully opened?
The user must be behind our corporate firewall and then some additional authentication must occur before the Hyperlink will actually open.
Occasionally this authentication will fail due to networking issues. I want to build in some error checking and do a retry when this happens. 99.9% of the time a simply retry will work, if they're behind the firewall.
Not sure if this would help but when the authentication fails the IE Browser lands at a specific Address (ie: http://abcdefg.xyz.com/Authkm/Protected.asp) and the IE Header reads "HTTP 500 internal server error".
Any ideas?
Thanks...
JimS
Sub DoFollow(Target As Range)
ActiveWorkbook.FollowHyperlink Range("Areas").Find(Target.Value, , , LookAt:=xlWhole).Hyperlinks.Item(1).Address
End Sub
Is there a way to verify that the Hyperlink was successfully opened?
The user must be behind our corporate firewall and then some additional authentication must occur before the Hyperlink will actually open.
Occasionally this authentication will fail due to networking issues. I want to build in some error checking and do a retry when this happens. 99.9% of the time a simply retry will work, if they're behind the firewall.
Not sure if this would help but when the authentication fails the IE Browser lands at a specific Address (ie: http://abcdefg.xyz.com/Authkm/Protected.asp) and the IE Header reads "HTTP 500 internal server error".
Any ideas?
Thanks...
JimS
Sub DoFollow(Target As Range)
ActiveWorkbook.FollowHyperlink Range("Areas").Find(Target.Value, , , LookAt:=xlWhole).Hyperlinks.Item(1).Address
End Sub