MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Excel VBA or VB6 For Speed

This is a discussion on Excel VBA or VB6 For Speed within the MapPoint 2006/2009 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. ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Excel VBA or VB6 For Speed Excel VBA or VB6 For Speed

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Notices

Notice: Now taking orders for MapPoint 2009!


Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-23-2004
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 07-29-2004
Senior Member
Black Belt
  
Join Date: Jul 2002
Posts: 5,138
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 07-29-2004
John Meyer's Avatar
Senior Member
Blue Belt
  
Join Date: Jul 2002
Posts: 479
I agree with the above comment. Here is a quote from the help file that supports the claim..

Quote:
COM add-ins run in-process with MapPoint, so they generally run faster than COM applications do as stand-alone executables
__________________
John
http://www.support-pc.com

Order MapPoint 2006 Here
https://secure.mp2kmag.com/?refer=support-PC
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 08-14-2004
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

« Labelling pushpins in a printout | pushpin sets pick random spot NOT correct address????? »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
How do I speed up this code? RichardD MapPoint 2006/2009 Discussion 5 11-18-2005 10:55 AM
Open Map Speed Yazzy MapPoint 2006/2009 Discussion 1 06-27-2005 10:52 AM
Speed of the service sbedin MapPoint Web Service and Virtual Earth 0 12-21-2004 10:13 AM
Speed Print out Anonymous MapPoint 2006/2009 Discussion 0 12-26-2003 04:54 AM
How to speed up MapPoint Dean MapPoint 2006/2009 Discussion 0 08-30-2002 10:16 AM


All times are GMT -5. The time now is 11:37 PM.

Marketing Strategy - VSAT - Used Cars - Book a Hotel - Moving Services - Archive - Top

Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC5
MP2K Magazine
Visitor Map

Cheap Flights to Benidorm
Book cheap flights to Benidorm with Holiday Hypermarket. Whether Summer or Winter Benidorm is a great destination.

Spain Holidays
Find and book Spain Holidays with Travel Counsellors. Holiday destinations around the world including Spain.

Turkey Holidays
Istanbul is Turkey's prime attraction as it has the most beautiful mosques and palaces of the country; it has Byzantine churches and Roman temples. Book Turkey Holidays online.

Dubai Holidays
Dubai holidays provide you with exotic sights, desert safaris and superb cuisine. There is an extensive range of things to do and see!

Cheap Portugal Holidays
Want to know what the best time to book cheap Portugal holidays is? Well have a look on ulookubook.com for some useful information to save your cash. Golf, tennis and cycling are all very popular here.

Travel
Check out the travel options on Travel.co.uk.

Cheap Goa Holidays
Experience the world famous Wednesday Flea Market at Anjuna! Book cheap Goa holidays at On The Beach!


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