I have created a C# library's COM object in VBA code (Excel). This C# library logs all messages in the log file. I have written some code in finally method and wish to invoke it each time I close the object through excel. But whenever I close the object through excel it does not call the code available in finally method. Please suggest how should I forcibly invoke the finally code through excel.
-
Hi, by "code in the finally method" are you saying that you have some C# code that is using a try/catch/finally structure, and that the code in your "finally" block is not executed ?BillW– BillW2009-12-27 08:58:52 +00:00Commented Dec 27, 2009 at 8:58
-
Yes Bill, I meant code available in finally block.NewAutoUser– NewAutoUser2009-12-28 21:10:42 +00:00Commented Dec 28, 2009 at 21:10
Add a comment
|
1 Answer
You actually want your "finally" code to go in the Class Destructor. Once this code is written, it will execute when there are no instances of the class left. VBA (thus, VB6) doesn't have a garbage collector per se, but it does use reference counting to automatically clean up after itself. When there are 0 references to an object in memory that object's destructor will be executed and the object destroyed.
How would this work? When you create an instance of the Object that is 1 reference: Set MyClass = New SomeClass when that variable is set back to nothing the reference count is decremented back to 0. This can happen two ways:
Set MyClass = NothingIf your VBA Class Object is local in scope (declared in a procedure) then you really don't need to do anything to make sure the destructor runs, it will automatically execute when the procedure ends. If it is a module level variable in a VBA Class Module, then when the instance of the VBA class is destroyed all it's module level variables will be destroyed, and the destructor will run. If you have it as public/global variable in a standard module, then it will be destroyed when the host application is closed. Essentially it will behave like the Class_Terminate event in VBA.
Hope that helps!
