Excel 2000 and MapPoint 2006

  • Thread starter Thread starter Builder
  • Start date Start date
B

Builder

The MP06 Help insists the COM add-in works with Excel 2000, but I'm having
problems.

* installed MP06 on a system with Excel 2000 already installed
* installed the COM add-in
* when I click the 'Insert MapPoint Map' item in Excel 2000 it flashes but
nothing happens


Trying code in the Excel sheet (reference set to MP 13 Object Library)

Dim oApp As Object
Set oApp = CreateObject("Mappoint.Application")

throws Err 429: ActiveX Control can't create object

(so does Set oApp = CreateObject("Mappoint.Application.NA.13"))


Any ideas?

Thanks
 
Your code runs for me in Excel 2000 against MP2006.

Btw, you don't need a reference using late binding, although it does no
harm.

--
Jim
| The MP06 Help insists the COM add-in works with Excel 2000, but I'm having
| problems.
|
| * installed MP06 on a system with Excel 2000 already installed
| * installed the COM add-in
| * when I click the 'Insert MapPoint Map' item in Excel 2000 it flashes but
| nothing happens
|
|
| Trying code in the Excel sheet (reference set to MP 13 Object Library)
|
| Dim oApp As Object
| Set oApp = CreateObject("Mappoint.Application")
|
| throws Err 429: ActiveX Control can't create object
|
| (so does Set oApp = CreateObject("Mappoint.Application.NA.13"))
|
|
| Any ideas?
|
| Thanks
|
|
|
 
Back
Top