Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

importing excel file into mappoint

This is a discussion on importing excel file into mappoint within the MapPoint Desktop Discussion forums, part of the Map Forums category; I would like to import datas from excel into mappoint. I wrote this programm but there's an error 424. Can ...

  1. #1
    misterb83 is offline Junior Member White Belt
    Join Date
    Feb 2003
    Posts
    10

    importing excel file into mappoint

    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

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    importing excel file into mappoint

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

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

    Looks like a copy/paste bug.

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Oh! And move the declaratoin of MPApp out of the function. It needs to be global.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83