Problem with Excel Web Query importing
Hi,
I'm new here ... as writing a question ... but as founding a solution for my Excel issues, I was often a visitor - so thx for all previous help!
Now I have funny or scary issue with Web Query. I'm using VBA, but I found out that even trough Web Query dialog window I got same "error". I'm trying to get some data from Google Map - json stuff.
So I open a ... oh yes - Excel 2010 ... "get data from web" and in dialog box New Web Query under Address: paste this link ...
http://maps.googleapis.com/maps/api/...z&sensor=false
... if you click it, you'll see json structure of geo-location for some address (FireFox will open it, IE you need to select open if you didn't play with Win Registry). Same structure I see in dialog box ...
web_query_01.jpg
... but when I click Import I don't get same results ...
web_query_02.jpg
I've played with all options, but always same result. In most of cases this is working, but now I'm facing with this issue and I don't know what could be wrong.
Does anybody have any idea? Advice?
I would appreciate any kind of help ... thx, Marko
Last edited by DiCaver; 02-09-2012 at 03:01 AM.
Nobody? :-( ... Did somebody tried and did you get same error?
Hi DiCaver, unfortunately using this service in this way violates the T&Cs of the service unless you have a google map in your worksheet which you are displaying the results in
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
Hi Kyle123,Originally Posted by Kyle123
don't worry ;-) This Excel document have Google Map images, links to the location on there maps, Google Map T&C on one sheet, there logo, ... so I think that this is not a problem ... but I still have a problem with above issue
Cheers, Marko
Ok in that case then...
What info do you actually need from the geocoding, I'm assuming you don't need it all? It's easier to request and parse in code than a webquery
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
Before that issue everything was working normally ... WebQuery have downloaded info, putted in a cell and then with few "MID, LEFT, FOUND, REPLACE, ..." I've extracted and distributed on sheet(s) needed info.
So I know that there are other ways to get data from Google Map trough json, but I didn't like bunch of modules or class modules as this was working. Do you have any other idea how to download data from Google Map? I started with this Excel JSON conversion, but as I said - I didn't like bunch of classes and modules. So I started from this Google Maps API Web Services and WebQuery ... until now
So my main problem is at the moment, that I can't figure out why WebQuery in most cases is working and in some not ... see images in my first post ...
Thx for now ... cheers, Marko
I couldn't get a webquery working at all with JSON in 2003, I ran the below code without an issue however if it helps:
Sub Kyle() With Sheet1.QueryTables.Add( _ "url;http://maps.googleapis.com/maps/api/geocode/json?address=Buckingham+Palace+London&sensor=false", _ Sheet1.Range("D50")) .Refresh End With End Sub
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
Hi,
I'm using similar thing, except that collecting data from 3 cells ... and it is working in 95% cases ... and I still didn't found out why in those 5% doesn’t work
Try this address ... ?address=ulica+dr+horvata+4+2270+ormoz& ... and let me know the results. This is this location.
Cheers, Marko
It's a typo, horvata should be hrovata...
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
Shame on me... it is true! I've checked other samples and in every case when it is not working there is typo ... like I write - shame on me
Anywhay THX!
Cheers, Marko
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks