Hi,

I was looking at your tutorial sheets in relation to programming mappoint through excel and VBA. I am unfortunately however having problems with the small piece of code as follows

Dim oApp As MapPoint.Application

Private Sub CommandButton1_Click()

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

End Sub

I have a button on the spreadsheet to click as suggested, but the problem lies with the first line, this error occurs -
'Compile Error - User-defined type not defined'

I followe the instructions accurately but don't understand what my problem is. Regards, Ross

Hi,

So it seems that the compiler cannot find Mappoint.Application. I assume you have to set a reference to the type library somewhere. I dont know the IDE, but something as 'add' - 'reference' - then search for type library.

I do not know VBA, so please be patient with my answer

I think Wilfried is right.

Check the very first tutorial --

What's New at MP2K Magazine - The Magazine for MapPoint

( full set of links are at Working With Excel and MapPoint - MP2K Magazine )

Make sure you did this step -- "Now go to Tools | References and scroll down through the Available References. Check the box next to Microsoft MapPoint 11.0 Object Library (either North America or Europe) and click OK."

hope this helps.

Eric

Hi Eric\Willfred, thanks for your quick response.

Unfortunately I'm still having problems, it flags the line
Set oApp = CreateObject("MapPoint.Application.NA.11")

what does the NA.11 stand for? I'm using the european version of the software. I'm am extremely stumped guys!

Regards

Hi,

Please mention if you have a compile time or runtime error. I assume runtime this time. The string for the european version should be:

Code:

MapPoint.Application.EU.11

NA is North America, and 11 is the version.

Thank you kindly,

as you can probably guess, programming is not my strong point!

regards,

Ross

Hi,

No problem. If you have futher question just fire them here (after trying yourself of course We are all glad to help.

I think the .EU.11 part is optional, if the line is just

Set oApp = CreateObject("MapPoint.Application")

it will open whatever is the default MapPoint application whether it be MapPoint 2002, 2004, 2006 or North America or the European maps. If you have more than one version installed I think it will try to open whichever was last opened.

Eric