I designed a workbook that extracted the winning numbers from QuickDraw from
a web page using a query.
I then had it do all sorts of nice things matching my favorite numbers,
showing what I would have won, lost, etc.

Problem is the web query stopped working last week???
Apparently they must have changed the formatting in the source code and the
query returns nothing.
I've been trying workarounds but to no avail.
I can open the web page in IE and then do a copy and paste but I can't get
the web page to open
within Excel. Workbooks.Open URL & OpenText both return an error.

Any ideas would be greatly appreciated.

The web page is:
http://www.nylottery.org/ny/nyStore/...avRoot_302.htm

Thanks,
John