Saving time

F

fernando

Hi,

I have a excel workbook with VBA, including forms and
modules. The longer(complex) the code, the longer it
takes to save the file, how can i reduce this saving
time?, I already tried AppsPro's CodeCleaner which
helped, specially reducing file size, but not speed.the
file contains:

Components Count
Standard Modules 4
Class Modules 0
UserForms 13
Document Objects 15

Code Items Count
Sub or Function Procedures 168
DLL Declarations 0
Total Lines of Code 2525

Are these far from excel's limitations?

Thanks
 
B

Bob Phillips

You need to look at the code and see if it can be reduced by putting
commonly used code in separate subs or functions.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top