Release Memory....DO NOT FORGET !!!!!!

Hi guys !!!

Anyone knows how to Release Memory of any program in VB 6.0 SP3 ???

And objects? Is that: Set xlapp = nothing !!!!!


Thanks in advance ;)

That is how I do it. just set the refernce that you have, say to your dll and set it to nothing.

Code:

---

Set myDllServerObject = nothing

---

Quote:

---

Originally posted by billrogers
That is how I do it. just set the refernce that you have, say to your dll and set it to nothing.

Code:

---

Set myDllServerObject = nothing

---

---

Thanks Bill!!! ...but i have the Excel after i put the code below in the task manager of NT
and i want to release as well as Lotus Notes...but until know nothing.

See i have done these:

Code:

---

WBSource.Close False
WBMailDef.Close False
           
    Set session = Nothing


'Set myDllServerObject = Nothing  Which DLL do u mean?
    Set WsWork = Nothing 'sheet
    Set WSMail = Nothing 'sheet
    Set WBSource = Nothing
    Set WBMailDef = Nothing
    Set WBWork = Nothing

---

as for my prev. post I was just trying to give a generic exmple, not specific to excel or lotus.

I think what you have works, I am looking around to try and verify.