Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got it.
I am a bit ashamed as well. But I didn't believe that VBA was so complex (to make our lives simpler). I added a Class_Terminate routine to MyClass and indeed, it was not called as long as at least 1 pointer to the object survived. So VBA inserts code that keeps track of the number of pointers to an object and when that becomes 0 deletes the object. That implies that it is up to VBA to remove the object from memory or not and the programmer has no control over it. But it makes the programmers life more simple, no worry about cleaning up. Anyway it is clear now what happens and everybody was right. Thanks a lot. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I remove a calendar object I inserted in a spreadsheet? | Excel Discussion (Misc queries) | |||
How do I remove an embeded flash object from a spreadsheet? | Excel Discussion (Misc queries) | |||
Is it possible to Shell and remove Excel from memory? | Excel Discussion (Misc queries) | |||
How to remove a drawn chart object using VBA. | Excel Programming | |||
Remove hyperlink from a graphical object | Excel Programming |