How to close COM object in VBA code???

J

Jojo

I have a COM server object . It is been used in a VBA code like the
following:

Dim xxx As MyServer
set xxx = new MyServer

MyServer.exe has a main form and when this form closes, it cleans up
the memory. How can I close xxx so it will clean up the memory also?
I tried:
set xxx= nothing
It closes the MyServer application but it does not clean up the
memory. It basically does not call
~MyServer()

Thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top