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

Excel User-Defined Functions and MapPoint

This is a discussion on Excel User-Defined Functions and MapPoint within the MP2K Magazine Articles forums, part of the Map Forums category; Excel User-Defined Functions and MapPoint David Hager demonstrates how to incorporate MapPoint functionality into a user-defined Excel function Read the ...

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

    Excel User-Defined Functions and MapPoint

    Excel User-Defined Functions and MapPoint

    David Hager demonstrates how to incorporate MapPoint functionality into a user-defined Excel function

    Read the full article here --
    http://www.mp2kmag.com/a124--excel.udf.mappoint.html

    To post a comment or question click "Post Reply"

  2. #2
    labero is offline Junior Member White Belt
    Join Date
    Sep 2008
    Posts
    7

    Smile Re: Excel User-Defined Functions and MapPoint

    Would be glad to hear if the UDF functions work with MapPoint 2006 as well.

    Tried copying and pasting Hagers first example right into the Excel 2003 VBA Editor. Entering the values in the Excel sheet as proposed by Hager and invoking the formula with =StraightLineDist(A1, A2) just provoked an error message telling me that the function contained unknown text. (By the way, the MapPoint Object Library in the Tools Reference menu were ticked).

    Would otherwise be a very handy tool!

  3. #3
    labero is offline Junior Member White Belt
    Join Date
    Sep 2008
    Posts
    7

    Smile Re: Excel User-Defined Functions and MapPoint

    Well it did work in MapPoint 2006! I did a mistake when inserting the function in Excel VBA.
    Glad to see that the code bits you presented in your mini tutorial also works as UDF:s in Excel cells.

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

    Re: Excel User-Defined Functions and MapPoint

    Congrats on getting it to work! Do you want to post your spreadsheet as an attachment with some short instructions? Maybe it will help some other people.

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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. New user: Exporting multiple data sets to excel
    By rpone605 in forum Products: Pushpin Tool, Single State Mapper
    Replies: 0
    Last Post: 06-20-2006, 04:54 PM
  2. mappoint functions in visual c++
    By spirido in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 04-07-2004, 09:21 AM
  3. User-defined type not defined
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-01-2003, 08:46 AM
  4. Problems with copy and paste of user-defined territories
    By Ute in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-14-2003, 12:38 PM
  5. Disabling Cntl Key Functions from MapPoint Control
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-18-2003, 07:06 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