Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Minimum Programming Software

This is a discussion on Minimum Programming Software within the Development forums, part of the MapPoint Desktop Discussion category; I am at a stage in a consulting contract where there's a dire need to import the minimal Excel fields/data ...

  1. #1
    sbktex is offline Junior Member White Belt
    Join Date
    Sep 2007

    Minimum Programming Software

    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?)


    THANKS ! ! Scott
    THANKS !

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Blog Entries

    Re: Minimum Programming Software

    Re: #1, I'm sure it would be easier in Excel or some other address cleaning software. MapPoint doesn't have any duping or string manipulation features outside of whatever programming language you are using.

    What specifically does Excel VBA not do that you want to do? That might help to answer your question. As for VB Express, I would make sure there's not a commercial restriction (cannot use for business), but I don't have any experience with it not to recommend it... the help file examples in MapPoint are VB6 / VBA but it's pretty similar to VB.NET. If you go with VB.NET I would recommend the book Programming MapPoint in .NET, that might help over some of the minor syntax differences, or just check out a VB.NET article on MP2K Magazine.

    hope this helps!
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    sbktex is offline Junior Member White Belt
    Join Date
    Sep 2007

    Re: Minimum Programming Software

    Thanks Eric -

    For example, it won't recognize 'mappointctl.xxxx'

    Doesn't like...
    Dim objMap As MapPointctl.Map
    Dim objPushPin As MapPointctl.Pushpin
    Dim objDataSet As MapPointctl.DataSet

    Is dropping the "ctl" equate to the same thing? (I'm getting back into this right now)

    Dim objMap As MapPoint.Map
    Dim objPushPin As MapPoint.Pushpin
    Dim objDataSet As MapPoint.DataSet
    THANKS !

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Minimum Distance
    By JDells in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 06-05-2007, 03:12 PM
  2. Ambiguous messages ( programming or not programming? )
    By Mohamed in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-13-2006, 04:35 PM
  3. Trying to optimize of minimum miles driven
    By BobFromBoston in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-22-2006, 07:31 PM
  4. Minimum Map Scale?
    By bryker in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-09-2004, 05:21 PM
  5. Is there a way to determine the minimum distance b....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-22-2002, 05:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67