OK... awesome... I've gone through the first two tutorials. Those helped a great deal.
I'm working on incorporating the info I've gleaned on those into the current project. I think I'm getting the hang of the starting point on this at least. I need to have this process work where only the zip codes (10 to 15 of them) on an individual load are entered into MapPoint. Then, MapPoint would create a route in the order of the zip codes and output mileage information that goes back into Excel. But this is a significant first step...
I can see that your code identifies specific cell references using a coordinate system:
Code:
Worksheets("Sheet1").Cells(2, 2), _
Worksheets("Sheet1").Cells(2, 3), , _
Worksheets("Sheet1").Cells(2, 4), _
Worksheets("Sheet1").Cells(2, 5))(1) I wonder if it's possible to create an expression defining a range of cells and that includes an expression that could exclude that cell if it's empty, like if the list ends at 12 zip codes instead of the 15 cells that could have a zip code in them.
Also, when I take out the first line "
Worksheets("Sheet1").Cells(2, 2), _" it goes all weird. Evidently, it can't identify the location using JUST the City, State and Zip information. That's a bummer.
- co
EDIT: OK, I'm an idiot. I see you have a solution for part of my whining. I'll read further before venting more of my spleen.
