Using VB and MapPoint to get the distance between two points

[spcicka]

I am very new to Visual Basics and MapPoint, but am faced with the following task:

On a row in excel, I have two addresses. I want to call a function (macro?) in excel that will plot these points in MapPoint and return the distance between the two into a column in excel. I realize this is a VERY general question and I have nothing to work off of, but does anyone have a place to start or example code for this? Thanks so much.

 

[hiker95]

spcicka,

Welcome to the MrExcel forum.

There is a lot of information out there it you search the web for Using VBA and MapPoint to get the distance between two points