Hi Paul,

Your comment is very pertinent and interesting. I found many informations
that will help me.

Thank you very much.

" wrote:

I wish that I had the magic tool to save you the hours of work that
you'd like to avoid. Here are a few links that cover some issues.

Chip Pearson
http://www.cpearson.com/excel/optimize.htm

Charles Williams
http://www.decisionmodels.com/optspeed.htm

Optimizing for Size and Speed
http://www.microsoft.com/officedev/a...pg/013/013.htm

In this article we'll disclose the ideal methods for maximizing
loading performance and minimizing file size
http://archive.baarns.com/excel/develop/vbaperfm.asp


HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

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.