Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to a url and retreive info for a spreadsheet
I am trying to keep track of a pool for our hockey pool. I would like to set
up a spreadsheet that will automatically update the points totals for the various players each week or more often. Example i would like to find the points for Peter Forsberg Marcus Naslund Mike modano and about 30 more Is there a way to automatically go to NHL.COM stats page and pick up this info without having to look for each player individually? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to a url and retreive info for a spreadsheet
Check out this website:
http://www.vertex42.com/News/excel-web-query.html It explains how to run Excel web queries. It has a template for pulling multiple stock quotes that you might be able to tweak for NHL players. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Tazzy" wrote: I am trying to keep track of a pool for our hockey pool. I would like to set up a spreadsheet that will automatically update the points totals for the various players each week or more often. Example i would like to find the points for Peter Forsberg Marcus Naslund Mike modano and about 30 more Is there a way to automatically go to NHL.COM stats page and pick up this info without having to look for each player individually? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to a url and retreive info for a spreadsheet
Thanks this helps a bit. however it seems to bring too much information when
i do this because the table that I refered to contains more info than I need I will have to search for another web site that uses a different sxystem Tazzy "Ron Coderre" wrote: Check out this website: http://www.vertex42.com/News/excel-web-query.html It explains how to run Excel web queries. It has a template for pulling multiple stock quotes that you might be able to tweak for NHL players. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Tazzy" wrote: I am trying to keep track of a pool for our hockey pool. I would like to set up a spreadsheet that will automatically update the points totals for the various players each week or more often. Example i would like to find the points for Peter Forsberg Marcus Naslund Mike modano and about 30 more Is there a way to automatically go to NHL.COM stats page and pick up this info without having to look for each player individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|