View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Web Query Stopped Working


I also could NOT get the query to REFRESH.???
Tim's code useful
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
I just tried your url to bring up the web pageright click export to
excel worked fine. Send your wb to my address below if you like. From my
excel wb.
(Payout Info)
791071 06/15/2008 23:59 1 5 7 16 20 21
791070 06/15/2008 23:56 6 7 9 14 24 31
791069 06/15/2008 23:52 8 12 16 21 23 36
791068 06/15/2008 23:48 3 8 9 15 20 21
791067 06/15/2008 23:44 2 3 6 9 17 24
791066 06/15/2008 23:40 3 4 13 17 18 19

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ryguy7272" wrote in message
...
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