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 5 of 5

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 Desktop 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 ...

  1. #1
    o0beaner is offline Junior Member White Belt
    Join Date
    Mar 2007
    Posts
    1

    Problems exporting MapPoint data to Excel in embedded map

    My company uses a spreadsheet with an embedded map, and a few users are completely unable to export data from the map to an excel sheet.

    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.

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    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.

  3. #3
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    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

  4. #4
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    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).

    In Excel, debugging may be automatically engaged if there is an unhandled error in the VBA code
    Do you mean that the debuger is invoked automatically with an unhandled error ? So this means that it is possible that this message window is because an unhandled error. Did I understeand that right ? But then Excel will stop and show the execution point, or not ?

  5. #5
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    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.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting data to Excel - Not all geographies picked up
    By gcottin1 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-15-2005, 06:59 AM
  2. Exporting Changed data back to Excel
    By kbeese in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-17-2005, 04:57 PM
  3. MPControl embedded in excel - excel loses functionality
    By ruyasan in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-20-2004, 04:41 AM
  4. Updating an embedded map in Excel from linked data
    By Matt in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-13-2003, 10:27 AM
  5. Exporting data to Excel
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-28-2002, 03:57 PM

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