Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
clearing the clipboard | Excel Discussion (Misc queries) | |||
Clearing A Row | Excel Programming | |||
Clearing #N/A's in one go? | Excel Worksheet Functions | |||
Clearing #VALUE | Excel Worksheet Functions |