Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

10 Replies
jmvilaplanap
Specialist
Specialist

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

jmvilaplanap
Specialist
Specialist

Ups, is the opposite that you need.

Sorry!

jmvilaplanap
Specialist
Specialist

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi Jose,

If you implement it , please do send me the script, so that it will be helpful to me also.

Thanks

jmvilaplanap
Specialist
Specialist

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.

Anonymous
Not applicable
Author

I need only for US, Canada and mexico.

Anonymous
Not applicable
Author

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>

Anil_Babu_Samineni

With in the JS i didn't seen any popup Tags? Can you high light those if possible

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful