I came across a few articles which talk about setting objects to 'Nothing' after its usages to release memory though I did not find any specific pointer about normal variables.
I variable should be set to 'Empty' to deallocate memory, i.e.
******************************
Dim aVariable
aVariable = 1
aVariable = Empty
MsgBox IsEmpty(aVariable)
Dim aObject
Set aObject = CreateObject("Scripting.FileSystemObject")
Set aObject = Nothing
MsgBox aObject Is Nothing
******************************
******************************
Dim aVariable
aVariable = 1
aVariable = Empty
MsgBox IsEmpty(aVariable)
Dim aObject
Set aObject = CreateObject("Scripting.FileSystemObject")
Set aObject = Nothing
MsgBox aObject Is Nothing
******************************
For more on this refer here
commented on - 16th Feb 2010
Looks like some one has different thought here
Comments
Post a Comment
No spam only genuine comments :)