|
Web Query Stopped Working
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 |
Web Query Stopped Working
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 |
Web Query Stopped Working
Don,
It is some strange behavior especially when it did work (for years) without a glitch. I never did save the source for the original page (before it stopped working) but to the untrained eye (mine) it didn't look any different than before (but something obviously changed). Anyway..... Tim Williams answered my question in another post in this NG "Extracting Web Data" and provided some really neat code to accomplish what I was trying to do. Thread is he http://tinyurl.com/62945q I'll send you a copy of the completed wb (utilizing Tim's code) directly if you want to take a look at it. Thanks, John Wilson "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 |
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 |
Web Query Stopped Working
Don,
I think (not sure) that the query does refresh but for some reason (something embedded in the web page) it returns no data. I do wish that I had saved a before and after copy of the source on that web page to see what they did change. Thanks, John "Don Guillett" wrote in message ... 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 |
| All times are GMT +1. The time now is 06:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com