PDA

View Full Version : [SOLVED] Is necessary "Set Object = Nothing"



fredlo2010
04-05-2015, 06:48 PM
Hello,

I always thought that Seeing my objects variables to nothing was always and good practice and I also thought that VBA had a very bad garbage collector.

Apparently this is not the case?

I was watching a video on pluralsight.com
http://www.pluralsight.com/courses/custom-vba-class-development

And according to the class this is not necessary. I was reading some post on http://stackoverflow.com/ regarding this matter and some people agree with the man teaching the course.

Any ideas on this matter ? :) :) :)

Thanks

mancubus
04-06-2015, 01:54 AM
hi.

found this:
http://blogs.msdn.com/b/ericlippert/archive/2004/04/28/when-are-you-required-to-set-objects-to-nothing.aspx

fredlo2010
04-06-2015, 04:13 PM
Thanks a lot for the link mancabus;

I think its time for me to get rid of old habits. :) :) :)

mancubus
04-06-2015, 11:43 PM
you are welcome.
:)