MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Excel UDF to calculate distances using lat/lon

This is a discussion on Excel UDF to calculate distances using lat/lon within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I had been using a UDF that was posted here (or linked here) to calculate distances between two points using ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 08-26-2005
Junior Member
White Belt
 
Join Date: Aug 2005
Posts: 1
Excel UDF to calculate distances using lat/lon

I had been using a UDF that was posted here (or linked here) to calculate distances between two points using Excel and changed it to do driving time instead.

I have many addresses and have noticed that a couple cannot be found by Mappoint, but I have determined their respective Lat/Lon.

However, I do not know what format one could send the Lat/Lon so that MapPoint can locate them.

My concern is that I would have to change all of the addresses to Lat/Lon -I rather not have to.


Thanks in advance
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
calculate, distances, excel, lat or lon, udf


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Calculate distances Anonymous MapPoint 2006/2009 Discussion 1 11-18-2004 11:58 AM
Batch Distances?! Anonymous MapPoint 2006/2009 Discussion 0 01-21-2004 01:40 PM
Get distances using just two postcodes using VB6 & MapPo paulhartland MapPoint 2006/2009 Discussion 0 07-21-2003 11:45 AM
Calculate highway distances of a route C72831 MapPoint 2006/2009 Discussion 1 07-08-2003 04:00 PM
hi, we are using mappoint to get distances for ou.... Anonymous MapPoint 2006/2009 Discussion 3 07-05-2002 11:01 AM


All times are GMT -5. The time now is 04:48 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55