| 0 |
Subject: Excel VB hyperlink Q
Posted by: ProudestMonkey
- Sustainer [4462028] Wed, Jul 21, 2004, 08:34
I'm in a league through CBS and I find their formatting to be downright horrible for some things, so I do much of my research through a spreadsheet that I have created. I'm continually adding new features to it and one of the things I'm trying to add now are hyperlinks to each player's page on CBS.
I can currently download the player list and stats, but I'm not sure how to grab the hyperlink from a cell. Once I have it, I'm pretty sure I can add it to each respective player with a
(stuffhere).Hyperlinks.Add Address:=PlayerLink where PlayerLink = the value I've grabbed in the step I can't figure out.
I know I've seen some programs floating around here a few years back that could do just that (from SmallWorld at that time). I was wondering if anyone could give me a little hint as to what the code would look like?
TIA |
| 1 | RecycledSpinalFluid
Dude
ID: 204401122
Wed, Jul 21, 2004, 11:50
|
(stuffhere).Hyperlinks(1).name should do what you are looking for.
|
| 2 | ProudestMonkey
Sustainer
ID: 4462028
Thu, Jul 22, 2004, 16:40
|
Nice, that did the trick. Thanks a ton!
|
| 3 | RecycledSpinalFluid
Dude
ID: 204401122
Thu, Jul 22, 2004, 19:31
|
Now you are obligated to share your spreadsheet... :)
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|