Quote:
Originally Posted by BobBridges
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?