MapForums
Community of VE/MapPoint Users and Developers
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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
07-17-2005
| ||||
| ||||
| 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"         |
|
4 Days Ago
| |||
| |||
 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! |
|
4 Days Ago
| |||
| |||
| 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 Days Ago
| ||||
| ||||
| 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
__________________ |
 |
| Tags |
| excel, functions, mappoint, userdefined |
« "Excel Basics to Blackbelt": A Reference Text for MapPoint Integration
|
Developing with MapPoint and Excel - Getting Started »
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| New user: Exporting multiple data sets to excel | rpone605 | Products: Pushpin Tool, Single State Mapper | 0 | 06-20-2006 03:54 PM |
| mappoint functions in visual c++ | spirido | MapPoint 2006/2009 Discussion | 0 | 04-07-2004 08:21 AM |
| User-defined type not defined | Anonymous | MapPoint 2006/2009 Discussion | 1 | 05-01-2003 07:46 AM |
| Problems with copy and paste of user-defined territories | Ute | MapPoint 2006/2009 Discussion | 2 | 04-14-2003 11:38 AM |
| Disabling Cntl Key Functions from MapPoint Control | Anonymous | MapPoint 2006/2009 Discussion | 2 | 03-18-2003 06:06 AM |
All times are GMT -5. The time now is 10:22 PM.
