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: 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
 
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
Excel 2003 memory usage The BIG O Excel Discussion (Misc queries) 1 June 15th 09 07:18 PM
XL 2007 memory usage Dave F Excel Discussion (Misc queries) 5 August 21st 06 01:01 AM
Monitor memory usage JL Links and Linking in Excel 1 May 16th 05 10:05 PM
Monitor memory usage JL Excel Discussion (Misc queries) 0 May 13th 05 04:15 PM
Expanding memory usage Excel 2003 Tieme Woldman Excel Discussion (Misc queries) 0 March 9th 05 02:55 PM


All times are GMT +1. The time now is 11:58 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"