View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 21
Default VBA & Excel memory usage

I've written a pretty extensive app under Excel, using a
lot of VB code. The problem is now that it is very slow
and uses a lot of memory.

I have most of the cose in two large modules. Would
breaking it into smaller chunks help?

Are there good techniques for generically making a
programm lighter weight and more efficient? Now that it's
working, I want to to tune the app to make is as effieicnt
and fast as I can, short of a re-write or move to another
platform/language (which may be the longer-term solution).

Thanks

Kevin