poolhall
Active Member
- Joined
- Jan 9, 2009
- Messages
- 350
I have a little VBA script for Excel that I've been using for about 6 months without any problem until yesterday. The script uses a web query, and after it failed, I started debugging it and found that the query retrieves nothing.
Then I tried to manually use the Web Query Wizard in Excel and got this error: "This web query returned no data. To change the query, click OK, click arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query".
The page I was trying to retrieve is this: http://www.boxrec.com/list_bouts.php?human_id=14793&cat=boxer . Other pages from this website are also impossible to retrieve with a web query, though they look the same for me as before. I tried to play with web query setting but to no avail; still getting the same web query returned to data error.
Another user of the this VBA script is getting the same error.
Any ideas what causes the error and how to fix it?
Then I tried to manually use the Web Query Wizard in Excel and got this error: "This web query returned no data. To change the query, click OK, click arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query".
The page I was trying to retrieve is this: http://www.boxrec.com/list_bouts.php?human_id=14793&cat=boxer . Other pages from this website are also impossible to retrieve with a web query, though they look the same for me as before. I tried to play with web query setting but to no avail; still getting the same web query returned to data error.
Another user of the this VBA script is getting the same error.
Any ideas what causes the error and how to fix it?