This is some strange behavior! I tried it and couldn't get it working
either. You could copy/paste the data to Notepad (which removes all
web-formatting stuff) and then, from there, paste it in an Excel sheet.

Maybe they though people with powerful Excel Web Queries would win the
lottery too many times and put them out of business. :)

Regards,
Ryan---

--
RyGuy


"John Wilson" wrote:

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