GetDistance function for Latitudes and Longitudes |
Post Reply |
Author | |
Crystal Long
Microsoft MVP Joined: 21 May 2012 Location: Colorado Status: Offline Points: 35 |
Post Options
Thanks(0)
Posted: 18 Aug 2012 at 10:51am |
The shortest distance between 2 points is a straight line. Here is a function to do that. It does not take road routes into account.
GetDistance Function for VBA
Related video tutorials: Excel VLOOKUP to Calculate Distances using Latitude & Longitude (cc) by Crystal for VLOOKUP Week http://www.YouTube.com/watch?v=bc92JR2OPss Convert VLOOKUP equations to Access - Distances (cc) by Crystal VLOOKUP Week http://www.YouTube.com/watch?v=ED_Wd4w9PLk Feedback is appreciated, thank you Warm Regards, Crystal Microsoft MVP Remote Training and Programming Connect to me, let's build it togetherAccess Basics by Crystal http://www.AccessMVP.com/strive4peace Free 100-page book that covers essentials in Access http://www.YouTube.com/LearnAccessByCrystal ~ have an awesome day ~ through sharing, we will all get better |
|
Warm Regards,
Crystal Microsoft MVP Remote Training & Programming Let's Connect and Build Together http://www.AccessMVP.com/strive4peace http://YouTube.com/LearnAccessByCrystal ~have an awesome day ~ |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |