Set xlWB = Nothing/Set xlApp = Nothing

[foolios]

I have been reading comments about programs needing to release memory after they are finished. I saw an article at:
http://www.tushar-mehta.com/excel/vba/xl_doesnt_quit/

That discusses using these methods when closing a workbook.

    Set xlWB = Nothing     Set xlApp = Nothing</pre>

I do not know what version of Excel they may be writing about but I am wanting to know if these are still practical for all Excel workbooks(2007/2010)?

Should I also set all my variables to nothing as well as I near the end of code execution?

Thanks for any tips on how to release memory this way, or if this practice is no longer necessary.

 

[shg]

IMO, there are some arcane cases where it is necessary, but in general, VBA releases all variables when they go out of scope, and it is unnecessary clutter to do it explicitly.

 

[foolios]

Thank you for your reply.