| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Camera Tool Leaks memory stops VBA
I have a macro which loads a template file with an Excel dashboard
report in. This includes several camera tool objects. It works Ok first time then the macro slows to a stop the next. If I remove the camera tool objects it is fine. I can only assume they are hogging memory. Anyone found this or have a solution? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Camera Tool Leaks memory stops VBA
I had a similar problem when I was defining multiple Worksheet objects and
not setting them back to "NOTHING" when I wasn't using them anymore. -- HTH, Barb Reinhardt " wrote: I have a macro which loads a template file with an Excel dashboard report in. This includes several camera tool objects. It works Ok first time then the macro slows to a stop the next. If I remove the camera tool objects it is fine. I can only assume they are hogging memory. Anyone found this or have a solution? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Camera Tool Leaks memory stops VBA
On Apr 8, 3:24*am, wrote:
I have a macro which loads a template file with an Excel dashboard report in. This includes several camera tool objects. It works Ok first time then the macro slows to a stop the next. If I remove the camera tool objects it is fine. I can only assume they are hogging memory. Anyone found this or have a solution? Try adding "DoEvents" to let the operating system swap out to other non-Excel OS/cleanup tasks. Probably won't help - but it's a good idea! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Camera tool & Excel 2007 | Excel Discussion (Misc queries) | |||
| Available resource limits, memory leaks and linked files | Excel Programming | |||
| Huge Memory Leaks using ODBC Drivers from Excel to retrieve data | Excel Programming | |||
| documented memory leaks in Excel 2003 or OWC11? | Excel Programming | |||
Linear Mode
