View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Jac Tremblay[_3_] Jac Tremblay[_3_] is offline
external usenet poster
 
Posts: 30
Default Bottlenecks in an Excel VBA application

Hi Rob,

Thank you for the reference to your site. That will surely help me when I
get more time to check it out. What I have seen so far is very interesting.

"Rob van Gelder" wrote:

It's not the easy way - it's the hard way, but...
I have speed testing routines on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jac Tremblay" wrote in message
...
Hi everyone,

I need to evaluate what parts of an Excel Application are slower than
others
so that I can work on them to make the overall performance better. The
application was built over a 5 year period by someone I don't know and is
now
in Excel 2000.

Is there a tool (an application) that can easily identify the lines of
code
in an Excel application that cause (or may cause) a performance problem.
I'm
looking for a tool like Golden that can be used to evaluate an Oracle
application or query.

If that does not exist, is there another way to pinpoint the parts of an
application that should be optimized or checked?

The application contains about 24000 lines of VBA code in 22 modules and
uses many Excel files with different extensions (.xls, .xlt, .xla).

Thank you for your help.
--
Jac Tremblay