MapForums

qpgraphics4 · #1 (**permalink**) 03-18-2008

I imported a list of customers from excel and I would like to automate an individual map for each customer showing directions to our store. I know how to get directions manually, but I am working with several customers, so doing this manually would take a long time. Any help would be appreciated.

Wilfried · #2 (**permalink**) 03-19-2008

Hi,

You can automate this if you do some custom programming. Do you have programming skills?

qpgraphics4 · #3 (**permalink**) 03-19-2008

I have some programming skills, but it has been a few years since i have actually programmed. I am currently trying to refresh my mind with VisualBasic. Is there any code that is already written that I can use?

Eric Frost · #4 (**permalink**) 03-19-2008

There are some examples to get started at

Working With Excel and MapPoint - MP2K Magazine

I find it easy to code up ad hoc stuff in Excel VBA, that's probably my favorite "development platform" for MapPoint, for general work anyway..

Eric

qpgraphics4 · #5 (**permalink**) 2 Weeks Ago

I am trying to get the distance for each customer to a master location. Some address are returning the correct # of miles, and some address are returning a time (12:00 AM). This is the code I am using:

Dim dDistance As Double

dDistance = Math.Round(oRoute.Distance, 1)

How can I get the correct number of miles for the addresses that are returning 12:00 AM?

p.s. I am programming in VBA using MapPoint 2006

Wilfried · #6 (**permalink**) 2 Weeks Ago

Hi,

The Distance property of a Route object will return always the distance or 0 is it is not (or can not) calculated. But wy do you think that the value it return is a time?

qpgraphics4 · #7 (**permalink**) 2 Weeks Ago

I was hoping you could tell me why it could be returning a time instead of the number of miles. i'm stumped
here is a screen shot of some code and the values i am getting.

[IMG]file:///C:/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG]

Wilfried · #8 (**permalink**) 2 Weeks Ago

Hi,

Ok now I see what you mean. 1 thing we should be very clear. The Distance value is a floating point value representing the distance in miles or kilometers. It is not a time value.

However a time value is also just a floating point value. Thus for some weird reason it is displayed as a time value in your Excel.

Your code looks ok but I don't know anything of Excel. If someone can jump in here? There must be a way to tell Excel it is not a time value but just a floating point number to display.

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/automate-multiple-maps-7320.html
Posted By	For	Type	Date
Automate Multiple Maps - MapPoint Forums	This thread	Refback	04-01-2008 04:53 PM
A More Compact Method for Obtaining Lat/Long - MapPoint Articles - MP2K Magazine	This thread	Refback	03-19-2008 02:23 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple maps?	VC_Man	MapPoint 2006 Discussion	1	03-16-2007 12:02 PM
Manipulating multiple maps in Excel	briwagner	MapPoint 2006 Discussion	3	09-26-2006 01:33 PM
automate stop duration and multiple routes	samlinc	MapPoint 2006 Discussion	1	01-22-2006 10:44 AM
Importing multiple maps into Excel	dadburne	MapPoint 2006 Discussion	5	10-19-2005 12:07 PM
Error with Multiple Symbol Maps	Anonymous	MapPoint 2006 Discussion	1	01-13-2005 03:31 PM

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

MapForums

Automate Multiple Maps

Automate Multiple Maps

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/automate-multiple-maps-7320.html

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

Similar Threads

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/automate-multiple-maps-7320.html