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

MapPoint/Excel with VBA modelling capability...

This is a discussion on MapPoint/Excel with VBA modelling capability... within the Development forums, part of the MapPoint Desktop Discussion category; I am a very new user of both MapPoint and VBA. I am hoping to combine MapPoint and Excel through ...

  1. #1
    aotten is offline Junior Member White Belt
    Join Date
    May 2009
    Location
    Ontario, Canada
    Posts
    3

    MapPoint/Excel with VBA modelling capability...

    I am a very new user of both MapPoint and VBA. I am hoping to combine MapPoint and Excel through VBA for a modeling project involving the transport of food across Canada. This would involve modeling locations of processors, distribution centres, retail stores and likely consumers of the individual stores. Not only would these locations be mapped, but transport of food between them would need to occur within the model in the time domain, and microbiological growth associated with time/temperature profiles (which would vary for each stage of the distribution chain the food was in).

    Originally I assumed this would involve MP and Excel 'talking' back and forth during the simulation, but it appears this may be cumbersome and it would be best to input all information to MP from Excel after doing calculations - does anyone have experience with something similar? Is MP at all capable of what I am describing?

    Currently I have been playing around to learn VBA just by importing locations to MP from Excel and for my currently list of just retail stores it is a few minutes of processing - I can't imagine how long a full application may need to run for. Are there more & less efficient ways of doing data imports (I am currently locating pins by latitude and longitude coordinates in my spreadsheet)?

    Any input those with MP experience may have for me is welcomed
    Thank you in advance!!

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: MapPoint/Excel with VBA modelling capability...

    Hi aotten,

    Latitude and longitude are the fastest, but this requires that one geocode the addresses in the first place. Once you have these, you keep them.

    Most of your calculations are going to be outside of MapPoint. Using a COM Addin hurries things along. That is, you'd be automating both MapPoint and Excel from a programming environment such as the VBA Engine behind Excel, Access, VB6, C#, VB.Net, etc.

    One should always collect the answers to parameters and then refresh the map with the answers.

    Mike Mattys
    Mattys Consulting - Custom Programming

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Network Modelling with MapPoint
    By John.Sewell in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-09-2008, 12:40 PM
  2. Help W Excel Mappoint VBA
    By Eric_j_wick in forum MapPoint Desktop Discussion
    Replies: 9
    Last Post: 04-24-2006, 11:49 AM
  3. MPControl embedded in excel - excel loses functionality
    By ruyasan in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-20-2004, 04:41 AM
  4. Capability of MapPoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-29-2003, 11:54 PM
  5. Does MapPoint have the capability to plot zip code....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-14-1999, 08:00 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