VBA Hyperlink

[dimitri]

Hi,
I'm trying to access a hyperlink in VBA. The full link is held in a cell in sheet 1. I'm having trouble getting the last line of my code to work. any help would be appreciated. thanks.

Sub OpenReport()
Dim Link As String
Link = Range("Full.Link").Value
Worksheet(1).FollowHyperlink Link
End Sub

 

[Jerry Sullivan]

Hi Dimitri,

It's hard to tell if you are trying to reference a named range, an existing hyperlink or a cell value that could be used as a hyperlink address.

Here are a couple of options that might in either of those situations.

If you have a text value that represents and address in a cell or named cell want to follow that value...

ActiveWorkbook.FollowHyperlink Address:=Sheets("Sheet1").Range("D2").Value
 
'or
 
ActiveWorkbook.FollowHyperlink _
   Address:=Sheets("Sheet1").Range("MyNamedRange").Value

If you have an existing Hyperlink in a single cell and want to follow that Hyperlink...

Range("D2").Hyperlinks(1).Follow

Just let me know if I misunderstood.

 

[dimitri]

JS411,
Sorry for the opacity, I was referencing the file path in the form of a text string which was held in a cell. I slightly modifies the second option you suggested and it works perfectly. Thanks for the help!