Followhyperlink using an address listed in a cell

[bdmangum]

I'm attempting to use the ActiveWorkbook.FollowHyperlink command to open a browser using an address located in a cell. I need to do it this way due to having a large list of objects and the window has to open a different webpage based upon the object selected. Basically I need to be able to set the address using a string variable, instead of a string address.

Here is my code

Private Sub Label3_Click()
Dim linker As String

linker = Worksheets("Object List").Cells(Counter, SubCounter + 2).Value

'Thus linker now is equal to "[URL unfurl="true"]www.microsoft.com"[/URL] simply set as a test

ActiveWorkbook.FollowHyperlink Address:=linker, _
    NewWindow:=True

End Sub

I receive a run-time error '-2147221014(800401ea)': Cannot open specified file.

 

[PHV]

ActiveWorkbook.FollowHyperlink Address:="

http://"

& linker, NewWindow:=True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bdmangum]

I figured out the problem. I was inserting the address using only "

http://www.etc.com"

when the string requires it start with "

http://".

Private Sub Label3_Click()
Dim linker As String

linker = Worksheets("Object List").Cells(Counter, SubCounter + 2).Value

'Thus linker now is equal to "[b]http://[/b][URL unfurl="true"]www.microsoft.com"[/URL] simply set as a test

ActiveWorkbook.FollowHyperlink Address:=linker, _
    NewWindow:=True

End Sub