Open Webpage Based on Data in Excel

[tac383]

Hi,

I have a list of baseball players that I want to be able to have hyperlinks to.

So for example, if I click on the cell with "Albert Pujols" name, I want to be able to run a macro that goes to http://en.wikipedia.org/wiki/Albert_Pujols, where the names would always be in the same format.

I know this:
ActiveWorkbook.FollowHyperlink _
Address:="http://en.wikipedia.org/wiki/"

But I'm thinking there must be a way to concatenate the wiki link and the name in order to put it into a website format.

Thanks.

 

[Norie]

Have you tried the HYPERLINK worksheet function?

You could put the 'base' URL in one cell and then using concatentaion create the links for each player.

Worked for me and, even though I though it would be, the space in the name wasn't a problem.

<TABLE style="WIDTH: 214pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=286><COLGROUP><COL style="WIDTH: 149pt; mso-width-source: userset; mso-width-alt: 7277" width=199><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 149pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20 width=199> http://en.wikipedia.org/wiki/</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=87> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>Albert Pujols</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Albert Pujols</TD></TR></TBODY></TABLE>

Let's say you have http://en.wikipedia.org/wiki/ in A1 and the names from A2 downwards.

In B2 downwards you can add this formula:

=HYPERLINK($A$1&$A2, $A2)

 

[tac383]

Thanks! That was much easier than I was making it out to be.