Excel Camera Tool Leaks memory stops VBA

[john]

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?

 

[Barb Reinhardt]

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.

 

[gimme_this_gimme_that]

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!