Calculate distance and time between two addresses using google maps

[Ajw43022]

I'm using the UDF code provided here by Ashish Koul:

https://groups.google.com/forum/?fromgroups#!msg/excel-macros/VDWa1NuD_Rs/2kJ2-WpfFbYJ

However, I keep getting #VALUE error. Does this work for others? If so, any thought as to what is going wrong for me? I'm using Excel 2010 home and student edition, win xp.

thanks!

 

[hiker95]

Ajw43022,

The security settings on my PC will not allow me to download the workbook from the site you provided.

Maybe something below will assist you:

convert some latitude and longitude coordinates from "Degrees, Decimal Minutes" format to "Decimal Degrees" format
How to convert degrees/minutes/seconds angles to or from decimal angles in Excel 2000
http://support.microsoft.com/kb/213449

How to get lat/long coordintates with VBA Excel
http://www.mapforums.com/how-get-lat-long-coordintates-vba-excel-7094.html

Resources for determining your latitude and longitude
http://jan.ucc.nau.edu/~cvm/latlon_find_location.html

Finding the location of a non-US city
Here are some sites that have the locations of major cities in the world.
http://www.realestate3d.com/gps/world-latlong.htm
http://www.infoplease.com/ipa/A0001769.html

Getting LAT and LONG from address
http://www.mrexcel.com/forum/showthread.php?t=619691&page=2

http://tableaulove.tumblr.com/post/9290566377/quick-and-easy-geocoding-for-tableau

A Free Zip Code Database + Latitude and Longitude
http://federalgovernmentzipcodes.us/

 

[Ajw43022]

Thanks so much for the resources Hiker95! I'll check this stuff out.