uploading data from the internet in excel: fantasy pool project

engine22

Board Regular
Joined
Jul 5, 2007
Messages
62
Hi, I want to create a spreadsheet that will give the updated stats of all my players... I know a few things with vba, but i don't know where to start with this one... Anyone knows how to create such a thing if it is even possible... For the curious its for my hockey pool, I would like to be able to transfer the stats of my players from an internet website (nhl.com) to my excel spreadsheet...
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
You could use the web query to pull the information from the web. If each player has their own webpage and the links are identical with the exception of the players name in the link or another identifier you could run a loop to pull the data copy it to another sheet and then continue on with the next player.
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top