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