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

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" <oku@xs4all.nl> wrote in message
news:OfZoAs7CFHA.3924@TK2MSFTNGP15.phx.gbl...
> 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.
>
>

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

/fredrik