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

Using a macro to get a map into excel

This is a discussion on Using a macro to get a map into excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I am using excel to print invoices for my company and want to insert a small map from mappoint ...

  1. #1
    jimbob is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    2

    Using a macro to get a map into excel

    Hi,

    I am using excel to print invoices for my company and want to insert a small map from mappoint or autoroute for the delivery driver. I know a small amount of VB and was wondering if anyone knew how to write a macro in excel that could do this.

    I have the customers postcode (uk) in excel and need a 3 inch square image covering aproximately 1 sq mile.

    If anyone can help it would be much appreciated.
    Thanks,

    Jim

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Chris Gebhardt wrote some simple examples, see the article section: "Using MapPoint from Word, Excel, and Access". There are many more examples, look at bit thoughout the site.

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

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

    I've written a macro which will produce maps in excel.

    If you want I can send you the VBA code and you can take it from there. My code uses lat/longs.

    adam

  4. #4
    MrExcelui is offline Junior Member White Belt
    Join Date
    Mar 2009
    Posts
    1

    Re: Using a macro to get a map into excel

    To insert a map or image into excel is easy. The code in the link below is used for inserting images into word using VBA excel but just skip the word part and insert the image into excel instead and your problem is solved!

    Insert Image to Word, Resize Image, Insert Borders using VBA Excel

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. Possible to batch file/macro Import Data Wizard?
    By Oyjord in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-31-2005, 06:05 PM
  3. Replies: 0
    Last Post: 04-01-2005, 10:31 AM
  4. Select city iwth VB macro
    By tanguy_laverdure in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-12-2003, 09:38 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