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