Excel Camera Tool Leaks memory stops VBA

J

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?
 
B

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.
 
G

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top