MapForums
Community of VE/MapPoint Users and Developers
Problems exporting MapPoint data to Excel in embedded map
This is a discussion on Problems exporting MapPoint data to Excel in embedded map within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; My company uses a spreadsheet with an embedded map, and a few users are completely unable to export data from ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-08-2007
| |||
| |||
| Problems exporting MapPoint data to Excel in embedded map The users have identical hardware setups, most of which being brand new Dell D820s. here is a screen cap of the error I receive:  Clicking Switch To... just reproduces the error window, as does Retry. Cancel just produces an error that tells me that the data cannot be exported, and to check whether or not Excel 97 or later is installed, which is not in question. Anyone have any experience with this? ***edit*** Sorry, forgot to mention, this is using MapPoint 2004.         |
|
03-10-2007
| |||
| |||
| Re: Problems exporting MapPoint data to Excel in embedded map
Hi, It is possible that your program that uses mappoint is not pumping messages. Then you get that window if it uses a COM object. Another possibility is that you did not return soon inough from out of a mappoint event (even if you are pumping). I think the timeout is 10 seconds. Another possibility is that if you use the ActiveX that there is mappoint instance already in memory from a previous instance that is not properly destroyed. I think all reasons of this message are covered as far as I know.
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
|
03-12-2007
| |||
| |||
| Re: Problems exporting MapPoint data to Excel in embedded map
Another reason for this message is interactive debugging. The debugger sets a breakpoint which prevents the message loops from executing. In Excel, debugging may be automatically engaged if there is an unhandled error in the VBA code. HTH Paul |
|
03-12-2007
| |||
| |||
| Re: Problems exporting MapPoint data to Excel in embedded map
Hi Paul, Thanks for completing this. I forgot the debugging (I dont write bugs hehehe). Quote:
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
|
03-12-2007
| |||
| |||
| Re: Problems exporting MapPoint data to Excel in embedded map
Yes - it will stop and prompt to debug the code. Since mappoint is still executing out-of-process, the error gets compounded. |
 |
| ||||
| Posted By | For | Type | Date | |
| Using a DSN-less Connection to a SQL Server Database to Get Data for Maps - MapPoint Articles - MP2K Magazine | This thread | Refback | 03-20-2007 01:08 PM | |
| Delphi Address Verifier - MapPoint Articles - MP2K Magazine | This thread | Refback | 03-18-2007 07:34 AM | |
| MapPoint Download - MP2K Magazine | This thread | Refback | 03-15-2007 10:17 AM | |
| The Magazine for MapPoint - MP2K Magazine | This thread | Refback | 03-09-2007 03:52 AM | |
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 |
| Exporting data to Excel - Not all geographies picked up | gcottin1 | MapPoint 2006/2009 Discussion | 1 | 12-15-2005 05:59 AM |
| Exporting Changed data back to Excel | kbeese | MapPoint 2006/2009 Discussion | 0 | 05-17-2005 03:57 PM |
| MPControl embedded in excel - excel loses functionality | ruyasan | MapPoint 2006/2009 Discussion | 2 | 05-20-2004 03:41 AM |
| Updating an embedded map in Excel from linked data | Matt | MapPoint 2006/2009 Discussion | 0 | 05-13-2003 09:27 AM |
| Exporting data to Excel | Anonymous | MapPoint 2006/2009 Discussion | 0 | 08-28-2002 02:57 PM |
All times are GMT -5. The time now is 02:32 PM.
