Excel and MapPoint
 

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

Excel and MapPoint
 

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/mappoi.../#features_sec

Hope this helps,
Eric