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

[fmnunes]

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

[billrogers]

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

Set myDllServerObject = nothing

[fmnunes]

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.

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:

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

[billrogers]

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.