Excel and MapPoint

[James Batley]

I wasn't sure in which area this should be posted so I've
put it in the MapPoint newsgroup also.

I want to be able to load MapPoint 2004 and Load the
Import Data wizard from a control button in an Excel sheet.

Can this be done?

I currently have

Dim oApp As Object

Set oApp = CreateObject("MapPoint.Application")
oApp.Visible = True


This seems to open MapPoint but it doesn't stay open, it
just flashes on screen then disappears. There is no
record of it in the Task List.
If I cause the code to have a runtime error, the Mappoint
window stay but only because of the error.
I'm finding this very confusing, can anyone help?

Thanks, James

 

[Eric Frost]

This seems to open MapPoint but it doesn't stay open, it

just flashes on screen then disappears. There is no
record of it in the Task List.

Hi James,

I believe the MapPoint application is going out of scope and closing..
see the "Getting Started with MapPoint and Excel" example in a recent
MapPoint newsletter -
http://www.mp2kmag.com/update/mappoint.newsletter/2004-09-30/#features_sec

Hope this helps,
Eric