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?

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?

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!