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

Display Existing Map in Excel

This is a discussion on Display Existing Map in Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have an Excel workbook that includes bus route info. On an initial route summary page in the workbook I ...

  1. #1
    mjlacore is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    7

    Display Existing Map in Excel

    I have an Excel workbook that includes bus route info. On an initial route summary page in the workbook I have a cell that is a hyperlink to a previously created MapPoint map on my computer. I want to put a simple reference copy of that map, almost as a kind of "thumbnail" image, on that summary page, just to provide a quick overview of the area covered by the route. I can place a MapPoint North America map object on the page, but just can't figure out how to link that object to the saved map. I'd appreciate any suggestions.

    Thanks,
    Mark
    Mark J. LaCore
    Duluth, MN

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Do you need it to be a map object?

    Rather than pasting in an embedded map object, try just inserting a picture image. You can make a picture "hyperlink" to a file.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    mjlacore is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    7
    Hi, Eric.

    I was looking for a live link to the map rather than a static image, so that if the map changes for some reason, it is reflected on the Excel page. I have room for a large enough image that it really is more than a thumbnail, and I'd like it to update automatically.

    Mark
    Mark J. LaCore
    Duluth, MN

  4. #4
    Martel is offline Junior Member Yellow Belt
    Join Date
    Feb 2003
    Posts
    28
    You can link the file when you embed it. In your Excel workbook, insert an object. Select the Create from File tab and browse to your map. Check the "Link to File" checkbox. Whenever the Excel workbook is opened, the user will be prompted to refresh the link. The problem with this is as long as the Excel workbook is open, your MapPoint file will be locked (toggled as read-only). Another potential problem is that your source file can be edited from Excel (right click, select Map Object and Edit). Doing this will open the file in MapPoint. Whatever changes that are made and saved will be reflected on the embedded object in Excel.

  5. #5
    mjlacore is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    7
    Thanks. Not sure why I couldn't figure that one out. Brain dead for a bit, I guess.
    Mark J. LaCore
    Duluth, MN

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Use CalcPos on a map with EXISTING pushpins ??
    By Sonicman_ in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 02-20-2006, 05:05 PM
  2. Adding Countries to Existing Territories
    By mblanco2000 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-28-2005, 12:14 AM
  3. How do you add records to an existing dataset?
    By stephenmillington in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-07-2004, 05:24 AM
  4. Looking for existing app to meet needs
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-01-2004, 12:44 PM
  5. Is it possible to add a new point to an existing p....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-17-2001, 02:38 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