VBA not releasing COM component memory ( built in C#)

Question

created COM component in C# and called it in VBA. VBA Code:

Sub test()

For i = 1 To 1000
    Dim p As ClassLibrary1.Point
    Set p = New ClassLibrary1.Point
    Dim surface As ClassLibrary1.surface
    Set surface = New ClassLibrary1.surface
    Debug.Print surface.Create(p)
Next i

End Sub

ClassLibrary1 consists of a DLL and a TLB (which I reference in my VBA)
ClassLibrary1 has classes and respective interfaces for Point and Surface.
When I run this, Excel causes an increase in memory (as seen from Windows Task Manager)
of 700KB (approx) and every time I run this, it increases and remains constant.
I tried setting the objects to 'Nothing' but it doesnt help. Any ideas?

I get your point Hans. Same thing as below. My program levelled out at 87k in Mem usage and stayed constant after that. — arhsim
– arhsim, Commented Feb 4, 2011 at 13:48

Conrad Frix · Accepted Answer · 2011-02-02 15:56:01Z

1

You probably don't actually have a problem the task manger reports the Working Set

The working set of a program is a collection of those pages in its virtual address space that have been recently referenced. It includes both shared and private data. The shared data includes pages that contain all instructions your application executes, including those in your DLLs and the system DLLs. As the working set size increases, memory demand increases.

You might want to see what the private bytes are which represent the actual memory that you are using. See this article from Tess Ferrandez

answered Feb 2, 2011 at 15:56

Conrad Frix

52.8k13 gold badges99 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

arhsim Over a year ago

Thanks a lot!! And your explanation is dot on! Thanks again.

Collectives™ on Stack Overflow

VBA not releasing COM component memory ( built in C#)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related