MapForums

misterb83 · #1 (**permalink**) 02-17-2003

I would like to import datas from excel into mappoint. I wrote this programm but there's an error 424. Can you help me????

Private Sub Form_Load()

load_mappoint
OpenDataSet

End Sub

Private Sub load_mappoint()

Dim MPApp As MapPoint.Application
Set MPApp = New MapPoint.Application
MPApp.Visible = True
MPApp.UserControl = True

End Sub

Private Sub OpenDataSet()

Dim objDataSets As MapPoint.DataSets
Dim objDataSet As MapPoint.DataSet
Dim zDataSource As String

zDataSource = "C:\Classeur1.xls!Sheet1!A1:B2"
Set objDataSets = objApp.ActiveMap.DataSets 'error 424, here!!!
Set objDataSet = objDataSets.ImportData(zDataSource)

End Sub

Anonymous · #2 (**permalink**) 04-14-2003

Change:
Set objDataSets = objApp.ActiveMap.DataSets 'error 424, here!!!

To:
Set objDataSets = MPApp.ActiveMap.DataSets 'error 424, here!!!

Looks like a copy/paste bug.

Anonymous · #3 (**permalink**) 04-14-2003

Oh! And move the declaratoin of MPApp out of the function. It needs to be global.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing Zip Codes from Excel to MapPoint	Jennl881	MapPoint 2006/2009 Discussion	2	02-05-2006 05:03 AM
Importing multiple maps into Excel	dadburne	MapPoint 2006/2009 Discussion	5	10-19-2005 12:07 PM
Error on importing shape file	Anonymous	MapPoint 2006/2009 Discussion	1	06-26-2003 10:26 AM
importing data from excel to mappoint	Layne	MapPoint 2006/2009 Discussion	0	05-09-2003 12:40 PM
When importing from MS Excel .csv files into MapPo....	Anonymous	MapPoint 2006/2009 Discussion	1	08-08-2001 07:35 AM

MapForums

importing excel file into mappoint

importing excel file into mappoint

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads