ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel97 not quit (https://www.excelbanter.com/excel-programming/299194-excel97-not-quit.html)

biu

Excel97 not quit
 
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

Tom Ogilvy

Excel97 not quit
 
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




Tushar Mehta

Excel97 not quit
 
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



All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com