MapForums
Community of MapPoint and Virtual Earth 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 ...
| |||||||
| Today's Posts | Twitter Feed | 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"         |
|
10-02-2008
| |||
| |||
 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! |
|
10-02-2008
| |||
| |||
| 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. |
|
10-02-2008
| ||||
| ||||
| 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
__________________ |
|
03-31-2009
| |||
| |||
| Re: Excel User-Defined Functions and MapPoint
you can do in copy and pasting in Excel 2003 VBA Editor.easy to modify in Excel 2003 .....
__________________ The Film Wall is a place where you can watch online free movies anytime. |
|
05-12-2009
| |||
| |||
| Re: Excel User-Defined Functions and MapPoint
I think that Excel is User-Defined Functions and MapPoint. this is the the best software for Database and mathematical calculation. so i like it.
__________________ The Film Wall is a place where you can watch online free movies anytime. |
 |
| Tags |
| excel, functions, mappoint, userdefined |
« Functional Programming with MapPoint and F#: Part 2
|
BackAndForwardUtility: A Simple .NET Add-in for Microsoft MapPoint »
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 11:58 PM.
