Clearing RAM
 

Hi,

I have redeveloped a system that uses Excel as its front end. There have
been some changes to the backend i.e a version update, and it appears to slow
things down. The CPU's are fine but after prolonged usage excel slowly grinds
to a halt.

Is there a way to write some code to clear the RAM? I might hard code it in
or put it on a button for the user to chose to clear the RAM.

Thanks

Nathan

Clearing RAM
 

I've had problems with the indexing service eating up memory. Check to see
if cisvc.exe is running in the task manager a kill the process. If this
solves the problem, then turn off the indexing serrvice from automatically
running at startup. You don't need the indexing service

"NathanG" wrote:

Hi,

I have redeveloped a system that uses Excel as its front end. There have
been some changes to the backend i.e a version update, and it appears to slow
things down. The CPU's are fine but after prolonged usage excel slowly grinds
to a halt.

Is there a way to write some code to clear the RAM? I might hard code it in
or put it on a button for the user to chose to clear the RAM.

Thanks

Nathan

Clearing RAM
 

Sometimes Excel/VBA is not 100% clever about cleaning up objects etc
automatically.

Here are some possible solutions:

- close and restart Excel.

- check your temp folder for large numbers of files and clean it up.

- Make sure that your code explicitly destroys all created objects and forms
using SET object to Nothing
and unload form. destroy objects from the inside to the outside container
(ie range before sheet before book). Also check for heavy use of copy/paste
or copying large volumes of strings.

- check for memory leaks: does the amount of memory used by the Excel.exe
process (use Task Manager) increase after prolonged use of the app? If so
check for known memory leak problems:
http://www.decisionmodels.com/memlimitsd.htm


Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"NathanG" wrote in message
...
Hi,

I have redeveloped a system that uses Excel as its front end. There have
been some changes to the backend i.e a version update, and it appears to
slow
things down. The CPU's are fine but after prolonged usage excel slowly
grinds
to a halt.

Is there a way to write some code to clear the RAM? I might hard code it
in
or put it on a button for the user to chose to clear the RAM.

Thanks

Nathan