So I'm calling Mappoint from within a VBA subroutine...

Dim SysApp As New MapPoint.Application
Dim SysMap As MapPoint.Map
Dim SysRoute As MapPoint.Route
Dim SysLoc1 As MapPoint.Location
Dim SysLoc2 As MapPoint.Location

Application.ActivateMicrosoftApp xlMicrosoftMappoint

and the calculator pops up instead...

I've opened Mappoint before from within an excel function, but this is silly...
My references are up mappoint 13.0 object library, mappoint utilities 1.0 type library, but am getting a "conflict message" when referencing mappoint control 13.0...

thanks for any input,
andriy

xlMicrosoftMappoint isn't a defined constant, so VBA doesn't really know what it's activating.

You probably want to simply activate the MapPoint application you already created in your variable "SysApp", by using the following:

Code:

SysApp.Visible=true
SysApp.UserControl=true
SysApp.Activate()

HTH
-Paul

Thanks.
I didn't realize Mappoint was already created once I declared it (and allocated memory).

Thanks for your patience with my growing skillset.
Andriy