ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Releasin Excel From Memory (https://www.excelbanter.com/excel-programming/297753-releasin-excel-memory.html)

PeteSmith

Releasin Excel From Memory
 
I have had a similar problem to most people in releasing XL fom memory

I have now revisited all my xl objects (most of which are publically declared) and set up tidy up routines whic
Marshall.ReleaseComObject on closing forms
I have also set option strict to On and sorted all problems there
But i am still having problems with Excel remaining in memory
This is due to in part to the fact that I am still debugging the application and my tidyup routines are not being called, but is probably something more problematic
So 2 questions
1. How can I get my tidyup routines to run when the I interrupt the application and close it from the debugger
2. How can I determine which Excel object is causing the problem, so that I can get to the root of the problem
3. There must be someting else other than setting objects to nothing and using Marshall.ReleaseComObject, which I need to do
Yours hopefully
Pet



All times are GMT +1. The time now is 09:14 AM.

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