Extracting Web Data
 

Can anyone tell me how to get what's on this web page into Excel (data or
source)?
http://nylottery.org/ny/nyStore/cgi-...avRoot_302.htm

Workbooks.Open URL and Workbooks.OpenText URL don't work.
Used to be able to do it with a web query but that recently stopped working
(probably due to a change they recently made to the page formatting).

Thank you.
John

Extracting Web Data
 

No problem - glad it worked for you.

Tim

"John Wilson" wrote in message
...
Tim,

That worked perfectly!!!!!
I hadn't mentioned in my post that I only wanted the table
but you went the extra mile and even parsed that out for for me.

Thank you.
John

Extracting Web Data
 

Tim

How would one modify your excellent code to this web site
http://www.nhl.com/nhlstats/app?serv...rt=points&pg=2

what I want to do is to pull and data queries Points&pg=1,points&pg=3 etc
thru to 9 and dump them all into sheet1

Thanks for any consideration.

Bart

"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
No problem - glad it worked for you.

Tim

"John Wilson" wrote in message
...
Tim,

That worked perfectly!!!!!
I hadn't mentioned in my post that I only wanted the table
but you went the extra mile and even parsed that out for for me.

Thank you.
John