I am having probems embedding a MapPoint map in Excel and then controlling the embedded map with VBA code. I am not sure how to reference the map. MS Excel seems to refer to the object as a shape... if I try to record a macro while making some changes to the map to get a better idea of what to do, the resulting code selects the shape and then uses some generic code like "Selection.Verb Verb:=xlPrimary".

I have tried to write some code to reference the shape such as:

----------
Dim myMap As MapPoint.Map
Set myMap = ActiveSheet.Shapes("Object 3")
----------

Also tried:

----------
Dim myMap As MapPoint.Map
Set myMap = ActiveSheet.Shapes("Object 3")
----------

But both result in "Type mismatch" errors.

Am I missing an obvious way to reference the embedded map? Thanks for the help!

[Correction to the original post]

The 2nd code snippet should read:

----------
Dim myApp As MapPoint.Application
Set myApp = ActiveSheet.Shapes("Object 3")
----------