Using a macro to close Excel itself
Posted by Michelle on July 16, 2001 8:30 AM
I have about 20 macros that are scheduled to run daily. They do their thing, print the reports, close all active sheets, and then leave all those instances of Excel up on the computer. The first thing I do in the morning is just close those blank instances of Excel down. They aren't really hurting anything, but I'm sure there is danger in volume. If I ever get to go on vacation for a few weeks, I'd be worried that my less-than-new workhorse PC could withstand a few hundred instances of Excel up.
Do you guys know of any way I could have the macro close down not only the reports, but also Excel itself?