MapForums

What error do you get?

I would recommend to go into the Program Files directory where the Microsoft MapPoint folder is located and at the command prompt type

> mappoint /regserver

This sometimes solves problems when different versions of MapPoint have been installed on the computer.

Do you have MapPoint North America or Europe?

Eric

__________________

Hi Eric,
I have the 2009 North American Map Point version. I also have Excel 2007 and have tried runnng the ap as both a .xlsm and .xls version.

I misstated in my previous thread. I am not actually getting an error message. I am not getting anything when I select the begin button. It is silent. I've been trying to use the distance zip code tab replacing the values in line 11 but nothing happens.

From the command prompt window I have attempted to go to the map point directory and type in > mappoint /regserver as suggested in your previous thread. Although I do not believe this is the solution I have been unsuccessful in attempting this because I am either doing it wrong because it fails to recognize in the command prompt window this path. I am sorely inadequate in using DOS.

I seem to be running out of options and really would like to be able to use this tool and wonder what else I can try.

jonesy

Perhaps you are not getting to the correct directory. First, open your Windows Explorer and find the exact path to your Mappoint 2009 directly, most likely it is: C:\Program Files\Microsoft Mappoint 2009. But check, yours may be different.
Then open the command prompt, found by going to Start-All Programs-Accesories-Command Prompt. When open type in (without the quotes) "cd c:\Program Files\Microsoft Mappoint 2009". (of course, use your path found above).
When in that directory, type in the command mentioned above: > mappoint /regserver
Hope this helps.

Ron H
Thank you. Correct. I had the wrong directory path and needed help on changing the directory. In addition I found that I had a setting in my version of excel preventing the maco from working. Once I corrected that and caught on to how the application works by changing values on line 11 that launched the map it all came together.

jonesy

Glad you got it working. Let me know if you have any suggestions for the spreadsheet. I'm hoping to release a new one in a month or two.
Eric

__________________

Hi Eric,
I am a new forum member and lo level MapPoint user. I need to calculate aprox. mileage between zip codes for about 2 million records. I donwloaded your Excel tools but it appear the calculator only works on single records. Is there a way I can automate this function? Also, I am now using Excel 2007 - will your add-ins work with that newer version? Thanks for your help.

It should work without any problem in Excel 2007. If you have a problem let me know, it would be a simple fix.

2 million is a lot of records. It would take a really long time and I'm not sure Excel is going to handle lists that size.

Do you need road distance or would straight line distance be sufficient? If straight line distance is OK, I could cook something up in Access...

Eric

__________________

Eric,

I only need straight line distance - does not have to be super accurate. An Access solution would be super.

Can you send me a sample of your data and describe what you would like to do specifically?

efrost@gmail.com

Eric

__________________

Eric,

Thanks for all your help on this solution. The Access macro works great - I was able to process my 1.5M records in less than an hour. I will provide you with a list of nice to have enhancements, but the basic functionality is there!

Flystol