My Excel 97 does not unload from memory even if its
window has closed after running a Macro. Do anyone has
any idea on that?

Thanks in advance.

Biu

assume you have started with automation. If so, you need to release all
references to it. All references created need to be done fully qualified
from the application down so they can be released by setting the reference
to nothing.

--
Regards,
Tom Ogilvy

"biu" wrote in message
...
My Excel 97 does not unload from memory even if its
window has closed after running a Macro. Do anyone has
any idea on that?

Thanks in advance.

Biu

For more along the lines that Tom mentioned, see the Excel/VBA/'Program
won't quit' page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
My Excel 97 does not unload from memory even if its
window has closed after running a Macro. Do anyone has
any idea on that?

Thanks in advance.

Biu