Using a CELL value to create a hyperlink 1

[Wray69]

I need to use a value in a CELL to create a hyperlink. So for example If I had TEST in my cell I would like to click a button and go to

http://Yahoo.com/Test

This is what I have so far;
Private Sub CommandButton1_Click()
ActiveWorkbook.FollowHyperlink Address:="

http://yahoo.com/",

_
NewWindow:=True

End Sub

I just cant figure out how to grab the cell value andd put it into the command.

Regards,

Wray

 

[DrJavaJoe]

try something like this:

ActiveWorkbook.FollowHyperlink "

http://yahoo.com/"

& Cells(1, 1), , True

 

[Wray69]

I get a Compile error when I try that...

Wray

 

[DrJavaJoe]

Sorry, not sure how that semicolon got there:

ActiveWorkbook.FollowHyperlink "

http://yahoo.com/"

& Cells(1, 1), , True

 

[DrJavaJoe]

I posted without the semicolon and somehow it's putting it in the post, so just remove it.

 

[Wray69]

Well I take out the semicolon and I get an automation error...

 

[DrJavaJoe]

Does this work, again without the semicolon.
ActiveWorkbook.FollowHyperlink "

http://yahoo.com/",,

True
And if so does the value "

http://yahoo.com/"

and the value in cell (1, 1) create a valid link. For example if cell a1 contained test then the command would try to open

http://yahoo.com/test

<- which is not valid. In this case you would need to handle the error.

 

[Wray69]

Here is what I have right now;

ActiveWorkbook.FollowHyperlink Address:=&quot;

http://yahoo.com&quot;

& Cells(16, 2), _
NewWindow:=False
And I get the error Cann not download the information you requested

If I went to the address by typing it in it is a valid address.

Wray

 

[DrJavaJoe]

Try this
dim strAddress as string
straddress = &quot;

http://yahoo.com&quot;

& Cells(16, 2)
msgbox strAddress
ActiveWorkbook.FollowHyperlink straddress, False

You should see a msgbox pop up with the exact location that is about to be browsed to. My guess is that you probably need to change &quot;

http://yahoo.com&quot;

to &quot;

http://yahoo.com/&quot;

 

[Wray69]

I get the Msgbox with

http://yahoo.com/test

and then I get a Runtime Error '5' Invalid Procedure call or argument. So it is linking the address together correctly.

Wray

 

[DrJavaJoe]

sorry you need to add another comma in front of False.

 

[Wray69]

Cool that did it.... Thanks for all the help.

Cheers,

Wray

 

[DrJavaJoe]

Excellent