MapForums

Hi,
I'm new to MapPoint 2004 Europe and I'm trying to use PinsToFile to get lat/long coordinate.

I can make some pins already (using find tool and then put the addresses) and normally it is called My Pushpins. But then when I run the PinsToFile.exe (in other windows), I get the following error message: Run time error '429': Active X component can't create object

I'm trying to reinstall Mappoint and Windows scripting 5.6 (I'm using XP) but no success so far.

Any help / suggestion would be terrific. thanks in advance

I did the experience and it works for me.

Juste follow the instructions
- Launch MapPoint
- Open a saved file or import pushpins (start with a small number of addresses to test)
- launch PinsToFile.Exe
- specify the name of the pushpin set you want to export
- press "Start Export"

To be sure,
- Copy PinsToFile.exe in the same directory as Mappoint
- Create some puspins and save them to test.ptm
- Open test.ptm with Mappoint
- Export some pushpins to an Excel file with a shaded form
- In the Excel file you will see the right name of your PushPin SET
( May be "My Pushpins" is wrong , in French it's "Mes clics-infos" )
So copy the exact name in Excel an paste it in PinsToFile )


Hope it works for you now.

But If you do your own programm you can be sure to have good results.
It's very easy to export Lat/lon programmatically. Just take some time to search in this forum.

Good luck.
Cool

__________________
Mohamed
www.AtlasCouscous.com

Thanks. But unfortunately it didn't work to mine....I constantly got the same error message (runtime error 429 bla bla bla). Even I had tried Pushpin Tool (demo version) with only 4 points in the map and got the same message.

I try to install MapPoint Europe 2004 to other machine, but I got another error message from PinsToFile, which is runtime error 4010 (or something) saying that the selected data doesn't exist and Pushpin Tool export a blank excel document.

In both computer I can export to excel without any problem, even for a rather big map (more than 100 points). Only that I don't get lat/lon coordinates.

I am so frustated. Is this something to do with my machines (both are running XP SP2 and MP 2004)? But why I get different error message then? Or there are missing files I need to install?

Please, any help would be very kindly appreciated.

Hi,

Take it easy. I don't want you be frustrated during this week-end !!!!

I tried to reproduce that 429 error runtime, and I get it when Mappoint is not launched.

YOU HAVE TO LAUNCH MAPPOINT AND LET IT OPEN DURING YOUR OPERATIONS

So,

1. Open MAPPOINT Application first
2. Create some pushpins in MAPPOINT
3. LET MAPPOINT Application OPEN
4. Go to Windows Explorer
5. Launch Pins2File.exe
6. If the pushpins SET is wrong, you will get
another runtime message "-2147181454(80049c72)"
7. The file latlon.txt is in the same directory as PinsToFile.exe


Ciao

__________________
Mohamed
www.AtlasCouscous.com

it's working now. I reinstall windows and it works like a charm.

So, apparently there was problem with other softwares (at this moment I just install office xp and mappoint in this computer). It is very strange that the script gives different error messages on two machines (and yes indeed i did correctly as in your suggestions)

Thanks. you're really cool, man. have a nice weekend too. greetings from holland.

Hi

this appeasrs to be exactly what I am looking for - to get lat long from UK postcodes. But, where do I get pins2file.exe from.

Aplogies if I am missing something obvious

Regards

RVS

Hi,

You find every thing in the forum !!


http://www.mp2kmag.com/downloads/pinsfile.zip
This was contributed by Gilles Kohl. It iterates over all pushpins in a set you can specify by name ("My Pushpins" by default), and writes their names and coordinates to an ASCII file. See the Readme.txt file for more information.

Regards

__________________
Mohamed
www.AtlasCouscous.com

Hi

Many thanks - it works perfectly . The problem was knowing where to look for it.

Cheers

Rob