Problem with Excel Web Query importing

[DiCaver]

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

[DiCaver]

Nobody? :-( ... Did somebody tried and did you get same error?

[Kyle123]

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

[DiCaver]

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

Hi 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

[Kyle123]

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

[DiCaver]

... It's easier to request and parse in code than a webquery ...

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

[Kyle123]

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:

Please Login or Register  to view this content.

[DiCaver]

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:

Please Login or Register  to view this content.

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

[Kyle123]

It's a typo, horvata should be hrovata...

[DiCaver]

It's a typo, horvata should be hrovata...

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