Thread: [Solved] VBA and web data
View Single Post
 
Old 01-17-2014, 11:56 AM
YounesB3 YounesB3 is offline Windows XP Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2012
Posts: 37
YounesB3 is on a distinguished road
Default

Quote:
Originally Posted by BobBridges View Post
Yep, I get the same thing. I played around with the URL a while, in the program, and believe it or not, what appears to make it unhappy is the square brackets; my browser thinks they're valid, alright, but when I remove "[game]" from the URL then the VBA error goes away.

This may not be good news for you. Unless there's a way to persuade VBA that this is a valid URL, or a way to get the data from metacritic without the square brackets, you may have to rethink your solution. But the first thing I'd do is start asking around to see whether there's an Excel setting that'll tell it to be less stringent about valid URL characters. Maybe you'll be able to Google something about it. Failing that, maybe the folks at metacritic can offer you a workaround.

I might have googled it myself, but I gotta go soon; I have a meeting in a few hours.
Thanks for that indication..!

I've simply put the "[game]=1" portion in my L4 formula and it seems to work for now.


Now I need help for the next steps! :P Should I make another topic?
Reply With Quote