I am at a stage in a consulting contract where there's a dire need to import the minimal Excel fields/data (from a spreadsheet with extraneous tabs and fields) to effortlessly as possible build individual Mappoint files with pushpins and Driving directions. I've got at least a couple interrelated concerns (see UPPER CASE below) but will try to keep this to one thread.
Germane setup info:
Spreadsheet has 4K rows, 30ish columns. Primary sort is Col A,'Route Name', secondary Col E, 'Sched PickUpDelivery Time'. Col A has about 80 different values (by route name), with each route having 50ish rows designating deliveries. Columns H,I,J,K have operative address info for export to MP, and as you might suspect, there may be many rows (one delivery item per row) going to same address (repeating HIJK), and, a driver may need to stop at same the same address multiple times (separate legitimate instances of HIJK within a route that do need a separare pushpin). I strongly sense I should clean up everything using Excel VBA before I even call MP, but HOW MUCH VERSATILITY AND EASE DOES MAPPOINT PROGRAMMING OFFER (concatenation, ignore duplicate, etc?) that may actually make it easier then Excel?
Question #2: I have accomplished some easy intro coding and manipulating MP stuff via Excel VBA (Reference'd MP 13.0 in Tools), but am noticing early on I'm missing alot of what's demo'd here and other examples. Given the scope I described above, WHAT SOFTWARE DO I ACTUALLY NEED TO WRITE MODERATELY COMPLICATED CODE FOR MAPPOINT? (VB, VB Express, can I beef up Excel VBA?)
Thoughts?
THANKS ! ! Scott