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

open a map from Excel

This is a discussion on open a map from Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; I've been following the example in the Help menu, but am still having difficulty... Am writing an Excel macro, to ...

  1. #1
    andriy is offline Junior Member Yellow Belt
    Join Date
    Mar 2007
    Posts
    16

    open a map from Excel

    I've been following the example in the Help menu, but am still having difficulty...

    Am writing an Excel macro, to open a MapPoint 2004 map:

    Set mpApp = New MapPoint.Application
    mpApp.Visible = True
    mpApp.UserControl = True
    mpApp.OpenMap mpApp.Path + ("C:\Documents and Settings\A Kolos\My Documents\Excel Mappoint\LHIN.ptm")

    (just like in the example), although syntax asks for:
    object.OpenMap(Filename, [AddToRecentFiles])
    but I keep getting an error message that says the file can't be found...

    any thoughts?
    thanks,
    andriy

  2. #2
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    Re: open a map from Excel

    The line

    mpApp.OpenMap mpApp.Path + ("C:\Documents and Settings\A Kolos\My Documents\Excel Mappoint\LHIN.ptm")

    specifies an invalid path. Try removing the "mpApp.Path + " from that line.

    -Paul

  3. #3
    ChickaBam Sam is offline Junior Member White Belt
    Join Date
    Mar 2007
    Location
    Nashua, MT
    Posts
    1

    Re: open a map from Excel

    Can you show the code on that for Streets & Trips?

  4. #4
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    Re: open a map from Excel

    Streets&Trips does not have a programmable interface.

    -Paul

  5. #5
    benlecanard is offline Junior Member White Belt
    Join Date
    Aug 2007
    Posts
    5

    Re: open a map from Excel

    I know it is a purely newbie - silly question but can anyone post the proper code to open an existing map please?

    I must say I'm a bit lost with the "objmap", "objapp", "oapp" etc. codes & don't know what the "object" should be before "Open.map ("path")

  6. #6
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem to open Excel file
    By Chiara in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 03-27-2009, 09:17 AM
  2. Open Map Speed
    By Yazzy in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-27-2005, 11:52 AM
  3. How do you open a mapoint map in delphi?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 12-04-2002, 08:07 PM
  4. Open all pushpins balloons at once?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 9
    Last Post: 09-25-2002, 10:43 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