General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
20 Nov 11
17:39
Joined:
Date Joined:
27 Sep 03
I use Excel to pull data from www.sportinglife.com (amongst others) by using a web query in VBA. Until today all was fine, but now the web query freezes.
If I load the url in IE then it's fine - it loads almost instantaneously - but if I open up a new worksheet and bring up a new web query it takes an age to load (~ 2mins) and then when I try to import I get "contacting the server for information" dialog. I've left this running for 10 minutes or more without any success - and the only way I can stop it is to close down Excel in Task Manager - cancel button/break do nothing. During this, if I load the page straight into IE it loads without any problems.
Before anyone says it, yes, I know I could stick an IE control on a form and use the DOM to parse the HTML - and I do that for more complex minings - but I still don't understand why SL pages can't be accessed through web queries.
I've tried loading racingpost pages and they load and import just fine, as does www.amazon.com.
ta
If I load the url in IE then it's fine - it loads almost instantaneously - but if I open up a new worksheet and bring up a new web query it takes an age to load (~ 2mins) and then when I try to import I get "contacting the server for information" dialog. I've left this running for 10 minutes or more without any success - and the only way I can stop it is to close down Excel in Task Manager - cancel button/break do nothing. During this, if I load the page straight into IE it loads without any problems.
Before anyone says it, yes, I know I could stick an IE control on a form and use the DOM to parse the HTML - and I do that for more complex minings - but I still don't understand why SL pages can't be accessed through web queries.
I've tried loading racingpost pages and they load and import just fine, as does www.amazon.com.
ta
Show More
Might help if you say what page is giving problems, I'm having no problem importing stuff from SL into excel with simple webqueries
oh a reply! thank you for that..
url is:
http://horses.sportinglife.com/Full_Results/0,12493,471638,00.html
and another one which is causing the same error is
http://www.telegraph.co.uk/
the telegraph one has a flash ad at the top (bloody flash)... could it be that I wonder? I'm running excel 2007 - are you in 2010? Maybe that handles flash in web queries...
So to clarify, the above SL url loads fine from IE, but causes problems in webQuery from VBA and webQuery window off Excel sheet.
Thanks so much for this.
url is:
http://horses.sportinglife.com/Full_Results/0,12493,471638,00.html
and another one which is causing the same error is
http://www.telegraph.co.uk/
the telegraph one has a flash ad at the top (bloody flash)... could it be that I wonder? I'm running excel 2007 - are you in 2010? Maybe that handles flash in web queries...
So to clarify, the above SL url loads fine from IE, but causes problems in webQuery from VBA and webQuery window off Excel sheet.
Thanks so much for this.
Sportinglife link worked fine but the telegraph crashed my 2003 version too :( Could well be the flash, MrExcel site is probably your best bet to get an answer.
Thanks GJ - sorry you crashed...
Maybe the ads are using something new and whizzy that webQ just can't handle... would go some way to explaining the random nature of SL urls freezing. Yet another reason to hate flash ads
Just posted on tek-tips, but I'll post on MrExcel just to be sure.
thanks again.
Maybe the ads are using something new and whizzy that webQ just can't handle... would go some way to explaining the random nature of SL urls freezing. Yet another reason to hate flash ads
Just posted on tek-tips, but I'll post on MrExcel just to be sure.
thanks again.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539