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 6 of 6

Unmatched Address in VBA

This is a discussion on Unmatched Address in VBA within the Development forums, part of the MapPoint Desktop Discussion category; Hi everyone. This is my first post on the forum although I have been on the site before. I'm developing ...

  1. #1
    bernieg is offline Junior Member White Belt
    Join Date
    Mar 2010
    Posts
    4

    Unmatched Address in VBA

    Hi everyone. This is my first post on the forum although I have been on the site before. I'm developing a small Excel app for calculating driving expense between our offices and our clients. I'm attempting to import addresses from a spreadsheet but cannot figure out a way to allow the user to fix the addresses that go unmatched. Currently the unmatched entries are just skipped. I would like to have my macro call the Data Set Properties dialog but I cannot figure out how. Anyone have any ideas?

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Unmatched Address in VBA

    Hi,

    Each record has a Matched property. I think that is what you need.

  3. #3
    bernieg is offline Junior Member White Belt
    Join Date
    Mar 2010
    Posts
    4

    Re: Unmatched Address in VBA

    Thanks for the reply Wilfried, but I'm not sure what you mean.
    I have an Excel macro theat uses MapPoint to calculate distance and time from our office to our client locations. Out of 100 address 3-4 go Unmatched and are simply skipped. Currently the macro displays a MSGBOX that tells the user that they have n number of skipped locations.

    What I would like to do, would be to call the MapPoint Data Set Properties dialog and allow the user to select an alternitive address.

    Another solution would be to use VBA and recalculate the unmatched address by ZIP code, but I would rather let the user make the decision.

    Thanks,
    Bernie

  4. #4
    bernieg is offline Junior Member White Belt
    Join Date
    Mar 2010
    Posts
    4

    Re: Unmatched Address in VBA

    BTW, I'm using the Matched properity to inform the user that there were Unmatched locations.

  5. #5
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Unmatched Address in VBA

    Hi Bernie,

    I think the only solution is to use VBA and recalculate the unmatched address.

  6. #6
    bernieg is offline Junior Member White Belt
    Join Date
    Mar 2010
    Posts
    4

    Re: Unmatched Address in VBA

    Thanks. I was afraid that would be my only solution.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. UnMatched Records
    By JMBean in forum MapPoint Desktop Discussion
    Replies: 9
    Last Post: 02-23-2010, 10:31 AM
  2. Records Still Unmatched
    By alexramo in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-28-2010, 03:36 PM
  3. Unmatched records
    By fletch in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-09-2005, 10:24 AM
  4. Programmatically selecting Unmatched results?
    By mschoonmaker in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 01-21-2005, 08:13 AM
  5. export unmatched records
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-17-2003, 02:51 PM

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 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127