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 VBA or VB6 For Speed

This is a discussion on Excel VBA or VB6 For Speed within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have several MapPoint "Export to Excel" type functions now in VB6 that I run in debug mode. The exports ...

  1. #1
    DavidP is offline Junior Member White Belt
    Join Date
    Jul 2004
    Posts
    6

    Excel VBA or VB6 For Speed

    I have several MapPoint "Export to Excel" type functions now in VB6 that I run in debug mode. The exports take a ridiculously long time, 3-4 hours for 16,000 records. My theory is that if I plop the code in Excel that has to be open anyway, I could eliminate the VB process and possibly speed things up. I am curious to hear others experience with this. Is it faster? The code transition is easy enough but I don't want to go through the trouble if it isn't faster.

    Thanks
    David Puckett
    Bright Rain Solutions

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Are you using the MapPoint Control OCX?

    I have found that if you write the VB6 code as a MapPoint Addin it generally runs 30 to 40 times faster.

    Roger

  3. #3
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    I agree with the above comment. Here is a quote from the help file that supports the claim..

    COM add-ins run in-process with MapPoint, so they generally run faster than COM applications do as stand-alone executables

  4. #4
    DavidP is offline Junior Member White Belt
    Join Date
    Jul 2004
    Posts
    6
    I just wanted to update this post with what I have learned. I turned my Mappoint utility VB6 project into an MP add-in and it's true, it is way faster. To the tune of 80% faster. It was well worth the effort. However, running it in debug mode slows it way down albeit not as slow as before.

    Thanks for the input.
    David Puckett
    Bright Rain Solutions

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I speed up this code?
    By RichardD in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 11-18-2005, 11:55 AM
  2. Open Map Speed
    By Yazzy in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-27-2005, 11:52 AM
  3. Speed of the service
    By sbedin in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 12-21-2004, 11:13 AM
  4. Speed Print out
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-26-2003, 05:54 AM
  5. How to speed up MapPoint
    By Dean in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-30-2002, 11:16 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