Diff. btw. Unload and Set obj=Nothing? (Win2000/O2K -UK)

Topic

New Reply

Hi,

(Env. Win2000, Off.2000-UK)

Can someone explain me the difference between the
“Unload” and the “Set myObj=Nothing”

According to the help the “Unload” statement:
“Removes an object from memory.

When an object is unloaded, it’s removed from memory and
all memory associated with the object is reclaimed. Until
it is placed in memory again using the Load statement, a
user can’t interact with an object, and the object can’t
be manipulated programmatically.”

I thought “Set myObj=Nothing” did the same ?
– is that correct ??

;o) henrik

Reply | Quote

Replies

The online help is slightly confusing here. Load and Unload don’t apply to objects in general, but are specific to UserForms (and forms controls). When you hide a UserForm, it is still loaded in memory, so that you can get at the value of text boxes etc.; you use Unload to remove the UserForm from memory after you have retrieved the information you need.

So you could have code like this:

UserForm1.Hide
strLastName = UserForm1.TextBox1
Unload UserForm1

Set objectvariable = Nothing is used to release object memory for all kinds of objects. For example:

Dim doc As Document
Set doc = Documents.Open(“C:WordReport.doc”)
‘ do something with the document
‘ …
doc.Close SaveChanges:=wdSaveChanges
Set doc = Nothing

You would get an error message if you tried to Load or Unload the doc variable, since it is not a UserForm.

Reply | Quote

Thanks Hans,

So simple and obvious, when explained this way…

;o)) Henrik

Reply | Quote