Reduce File Size
I have a workbook that is over 55meg. It has an above average number of worksheets and modules.
The file has very little formatting or formulas. Functionality is handled by VBA script in modules. There is a total of about 100 modules. So it is going to be difficult to copy them to another file and paste them back.
I have gone to each worksheet to delete unused rows and columns and deleted formatting where it is not used.
I tried running an "excel diet" function i found on the web, but it would not run.
The size of this file is making it difficult for my users to load, run and save.
Any suggestions will be greatly appreciated.
How many sheets as this may also impact. see link re memory issues
response re reduce file size
I used a separate module for each sub so that i can document the location and purpose for each sub. Is there a better way?
And there are are about 40 worksheets in the file.
Thanks for the help.
I can't see how that makes it easier. I usually categorise procedures & place eacg category into a separate module.
Originally Posted by tbaker897
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By sujata_ghosh in forum Excel Programming / VBA / Macros
Last Post: 03-12-2008, 04:19 AM
By bullwinkle55423 in forum Excel General
Last Post: 02-04-2008, 12:02 PM
By khalid79m in forum Excel General
Last Post: 11-22-2007, 09:11 AM
By djmarak in forum Excel General
Last Post: 09-21-2007, 12:24 PM
By r_dearn in forum Excel Programming / VBA / Macros
Last Post: 09-25-2006, 04:44 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1