
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Macro to get address from latitude and longitude
Hi All,
I am having having a list of Latitude and longitude based on some dimension.
What I want now is to have the address, City, State, Country, Zip Code for all of these latitude and longitudes.
Please help me in crating a Macro which will read all the latitude and longitude from the application and return back the address, sity, state and country which I can use for further dashboard requirements.
Regards
Nitin
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
I published a excel macro to do it, you can see it in: Address2Coord.xlsm
I think is better than create the macro directly in QV because the 2000 get restriction.
Regards


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ups, is the opposite that you need.
Sorry!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found this https://www.mrexcel.com/forum/excel-questions/514384-reverse-geocoding.html
I'll try to add it to my excel.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
Thanks for the help,
Can you help me out with the reverse also.
As I am totally new to Excel macros scripting.....
Regards
Nitin Gupta

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jose,
If you implement it , please do send me the script, so that it will be helpful to me also.
Thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, I was taking a look on yesterday, but this webservice is only for US addresses...
If you find a webservice available for the whole world, please tell me and we try to implement it.
Thanks.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need only for US, Canada and mexico.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a html which takes lat long as input and gives the address in alert popup.
Its using googleapis in jScript.
Hope it can help you
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
Latitude:
<input type="text" id="txtLatitude" value="18.92488028662047" />
Latitude:
<input type="text" id="txtLongitude" value="72.8232192993164" />
<input type="button" value="Get Address" onclick="GetAddress()" />
<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false"></script>
<script type="text/javascript">
function GetAddress() {
var lat = parseFloat(document.getElementById("txtLatitude").value);
var lng = parseFloat(document.getElementById("txtLongitude").value);
var latlng = new google.maps.LatLng(lat, lng);
var geocoder = geocoder = new google.maps.Geocoder();
geocoder.geocode({ 'latLng': latlng }, function (results, status) {
if (status == google.maps.GeocoderStatus.OK) {
if (results[1]) {
alert("Location: " + results[1].formatted_address);
}
}
});
}
</script>
</body>
</html>
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
With in the JS i didn't seen any popup Tags? Can you high light those if possible

- « Previous Replies
-
- 1
- 2
- Next Replies »