Using VBA to download data from tables on multiple webpages into Excel

[Yankee9204]

Hello,

I am a graduate student attempting to do research on US lotteries. I would like to copy the data on the number of Powerball winners from the Powerball website into excel. The data from each drawing is located on separates webpages. The data goes back to 1997, and drawings are twice a week, so there are over 1,600 webpages from which to get data, making copy+paste not feasible.

I don't really care how the data gets into excel- once it's in there, I can manipulate it into a form to make it usable, as long as column headers and the date of the drawing is included. The data for the two most recent drawings are:

http://www.powerball.com/powerball/pb_totalwinners.asp?DrawDate=4/20/2013
and
http://www.powerball.com/powerball/pb_totalwinners.asp?DrawDate=4/17/2013

I need the whole table, including State, Powerball, Powerplay, and Total. The is a drop down menu with all the drawing dates available, so the dates are conveniently listed in the source code of the webpage.

I have seen some relatively similar posts, but I am unsure of how to modify the responses for the Powerball website. Any help on how to do this would be greatly appreciated!

 

[John_w]

Do you still need help with this? If so, have a look at code involving XMLhttp and HTMLdocument.