Quote:
Originally Posted by BobBridges
Really? You put the square brackets in another part of the URL and it worked? Now I'm not sure what to think.
Anyway, my suggestion is that you ask your next question here and I'll see what I think. If it's beyond my expertise, I'll suggest that you start a new thread, so that others will see it (instead of glancing at this one and mutter "oh, someone else already has this one").
|
Well basically now in VBA the code is :
Code:
Sheets("Temp").Select
URL = "URL;http://www.metacritic.com/search/all/results?cats" & Range("L4").Value
With ActiveSheet.QueryTables.Add(Connection:=URL, Destination:=Range("M5"))
And in cell L4 : ="[game]=1&date_range_from="&K2&"&date_range_to="&K3&"&sco re_range_from=60&search_type=advanced"
So for now, the only thing we managed to do is to connect excel to the website.
I need to collect the data from the website in question. So some type of information which is on this page :
http://www.metacritic.com/search/all/results?cats[game]=1&date_range_from=09-31-2013&date_range_to=12-31-2013&score_range_from=60&search_type=advanced
More specifically : game console, score of game, name of game and published date.
Do you know how?