LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Saving time

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving changes to option to apply all the time. Stuart A Excel Discussion (Misc queries) 1 November 12th 09 11:19 AM
Saving in 2007 and 2003 formats at the same time kjs Excel Discussion (Misc queries) 1 February 12th 09 06:47 PM
Saving files in two different formats at the same time Andy31313 Excel Discussion (Misc queries) 1 May 18th 07 09:54 PM
Need help for time saving! Jens 'Kluesi' Kluesener Excel Programming 2 September 26th 03 11:51 AM
Saving a time stamp with a macro? Ray Morton Excel Programming 4 August 5th 03 12:24 AM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"