Andy,
This will require programming using Gilles Kohl's CalcPos routine.
You can find it at www.MP2KMag.com
I am a freelancer, if you don't have a programming staff.
----
Michael R. Mattys
Mattys MapLib for Microsoft MapPoint
http://www.mattysconsulting.com
On Wed, 1 Jun 2005 02:31:51 -0700, andyuk
<and...@discussions.microsoft.com> wrote:
>I'm importing a spreadsheet into MapPoint 2004. This spreadsheet contains
>6000 grid references. Mapoint displays these as I want with pushpins.
>However, I need to capture the longitude and latitude coordinates of each
>then export them back into Excel.
>
>Any ideas how I do this?
Check out:
http://www.gilleskohl.de/pinsfile.zip
Regards,
Gilles [MVP].
(Please reply to the group, not via email)
I've tried your pushpins.exe but I get a runtime error -2147181454
(80049c72) that states "The requested member of the collection does not
exist. Use a valid name or index number". Can you help???
>Hi
>
>I've tried your pushpins.exe but I get a runtime error -2147181454
>(80049c72) that states "The requested member of the collection does not
>exist. Use a valid name or index number". Can you help???
Make sure the name of the pushpin set you want to export is specified
correctly - it defaults to "My Pushpins", but if you imported an Excel
sheet as you mentioned, it'll probably have the same name as the
sheet.
You can check the name of the set in the "Legend and Overview" pane in
MapPoint, under "Pushpins"