Quick question and I will apologize in advance if it has been posted before but I was not able to find it in the forums using a search.
My problem relates to getting my addresses into the Mappoint route planner in the same order that they are in my excel file.
Now from the reading I have done, I do understand that this is not a Mappoint feature and I also understand why Mappoint loads them in a different order.
So where was my thought.
If you open the route planner and add addresses 1 and a time, they automatically get listed in the order they are entered.
Based on this, I simply want to write a simple VBA macro to run from excel that launches Mappoint and basically adds my address information line by line as it appears in excel.
No need to format the excel file or be worried about checking the sequence as the file is generated as formatted in chronological order already.
Also, there will not be any blanks between rows, and a blank cell will indicate the end of the data.
Basic idea I have is that this import function will need to be done in a loop until it gets to a row with no data at which point it ends.
While I have a basic programming knowledge, I am not familiar wit the VBA code / function names from Mappoint to get this to work.
Any help would be appreciated.
(And no, I am not interested in purchasing Routewriter as I feel this should not be a complicated task for the simple use I need it for)