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 4 of 4

Macro to Export to Mappoint (from Excel)

This is a discussion on Macro to Export to Mappoint (from Excel) within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi All, I've created a routine that drags live sales order info from our as400 server into an Excel spreadsheet. ...

  1. #1
    infinityukok is offline Junior Member White Belt
    Join Date
    Aug 2007
    Posts
    3

    Macro to Export to Mappoint (from Excel)

    Hi All,

    I've created a routine that drags live sales order info from our as400 server into an Excel spreadsheet.

    I then have to select the Data > Export to Mappoint option when Excel loads.

    I'd like to write a macro to automatically 'Export to Mappoint' when i open the spreadsheet.

    Can anybody help? I'm more than happy to do the programming myself as i have a slight knowledge of VB but i just cant find enough references to get me going.

    Thanks

    Mark
    ???

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Macro to Export to Mappoint (from Excel)

    Take a look at these examples -- Working With Excel and MapPoint - MP2K Magazine see if this is enough to get you started. Let us know!
    Eric

  3. #3
    infinityukok is offline Junior Member White Belt
    Join Date
    Aug 2007
    Posts
    3

    Re: Macro to Export to Mappoint (from Excel)

    Thanks for the help eric, definitely on the right track now. Only problem is i'm having trouble getting the example code to work.

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

    I'm using version 13 so i tried substituting the "NA.11" part with NA.13... i got i slightly different error but this appeared to help...

    the problem is, i'm using the Europe version not the American version and i'm guessing the "NA." is a reference to North America or something like that.

    I've tried substituting the NA. for E. and EU. but no joy, any ideas?

    Thanks again.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Macro to Export to Mappoint (from Excel)

    Actually just try this

    Code:
     
    Set oApp = CreateObject("MapPoint.Application")
    That should just load up whatever version or flavor of MapPoint is installed on your machine. Where the .NA and the version number (e.g. .11) can help is when you have different MapPoint's installed and you want to specify which one to load. Good question!

    Eric

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using a macro to get a map into excel
    By jimbob in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 03-19-2009, 05:21 PM
  2. Excel macro based on Highlighted Mappoint pushpins
    By RHill in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-11-2006, 09:18 AM
  3. setting up macro in excel to extract lat/long from map point
    By TransportationNut05 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-24-2005, 11:45 AM
  4. Replies: 0
    Last Post: 04-01-2005, 10:31 AM
  5. updatelink using macro in Excel XP
    By amyles in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-17-2003, 02:26 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 84 85 86 87 88 89 90 91 92 93 94 95 96