Conserving Size

  • Thread starter Thread starter scrabtree23
  • Start date Start date
S

scrabtree23

I have written a very nice program. However, I want to
reduse its size. Does anyone have any good suggestions?
I have exported and re-imported my modules and forms and
this saved some significant space. Other suggestions?

SDC
 
Maybe if you posted some/all of your code we could critique it. It might
already be as efficient as it could possibly be.

Regards

Trevor
 
Here is a listing by Chip Pearson on how to optimize code.
http://www.cpearson.com/excel/optimize.htm

If the problem is related to file size, Debra Dalgleish
offers a suggestion or two on reducing file size.

http://www.contextures.com/xlfaqApp.html#Unused

If speed is an issue, Charles Williams has detailed a whole hostof
issues and probable fixes.

http://www.decisionmodels.com/optspeedd.htm#OpSave

David McRitchie offers a great deal of info on Slow Response and
Memory Problems.

http://www.mvps.org/dmcritchie/excel/slowresp.htm

HTH
Paul
 
Back
Top