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
 
Back
Top