Extreme slow performance of Excel while debugging from Visual Basic IDE.

  • Thread starter Thread starter Oscar
  • Start date Start date
O

Oscar

During debugging a VB-Active X dll which comunicates to Excel, the
performance of subroutines which retrieve data from a worksheet is very,
very slow. In case it is compiled, it operates more than 100 times faster.
However, debugging as such takes me too much time as I have to wait more
than 10 minutes only for reading data from some worksheets in the beginning.
I was wondering whether someone can provide me with any tips to optimalize
this debugging configuration.
 
Oscar said:
During debugging a VB-Active X dll which comunicates to Excel, the
performance of subroutines which retrieve data from a worksheet is very,
very slow. In case it is compiled, it operates more than 100 times faster.
However, debugging as such takes me too much time as I have to wait more
than 10 minutes only for reading data from some worksheets in the beginning.
I was wondering whether someone can provide me with any tips to optimalize
this debugging configuration.
Click to expand...

Maybe this will help: http://www.decisionmodels.com/fastexcel.htm

/fredrik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB.NET with Excel VBA 3
method Worksheets of object _Global failed 1
Visual Studio 2010 (Creating Excel DLL) "warning" no build 4
Excel slowness 3
debug automation add in written in VS2005 for excel 2003 2
Extreme Performance with 10 Years Warranty - SanDisk Extreme PRO Review 2
Extremely slow response times in Excel 2007 4
Excel 2007 extremely slow to delete cells 1

Back
Top