Is there a need to set Objects to Nothing

by

VB uses a so-called “reference counting” garbage collector.

Basically, the moment a variable goes out of scope, the reference counter on the referenced object is decremented. When you assign the object reference to another variable, the reference counter is incremented.

When the counter reaches zero, the object is ready for garbage collection. The object resources will be released as soon as this happens. A function local variable will most likely reference an object whose reference count never goes higher than 1, so object resources will be released when the function ends.

Setting a variable to Nothing is the way to decrease the the reference counter explicitly.

For example, you read in a file, and set the file object variable to Nothing right after the ReadAll() call. The file handle will be released immediately, you can take your time process its contents.

If you don’t set to Nothing, the file handle might be open longer than absolutely necessary.

If you are not in a “must unblock valuable resource” kind of situation, simply letting the variables go out of scope is okay.

More Related Contents:

  1. VB6 pass by value and pass by reference
  2. VBA : save a file with UTF-8 without BOM
  3. Does VBA have Dictionary Structure?
  4. What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?
  5. What does the Call keyword do in VB6?
  6. Difference between Visual Basic 6.0 and VBA
  7. IsDate function returns unexpected results
  8. Getting AD Details based on username
  9. VBScript – How to make program wait until process has finished?
  10. Determine real cause of ODBC failure (error 3146) with ms-access?
  11. VBScript to open a dialog to select a filepath
  12. Alternative IDE for VB6 and VBA [closed]
  13. User Defined Type (UDT) as parameter in public Sub in class module (VB6)
  14. VBA macro that search for file in multiple subfolders
  15. HTML Text with tags to formatted text in an Excel cell
  16. Get list of Excel files in a folder using VBA [duplicate]
  17. Getting Error 3340 Query ‘ ‘ is corrupt while executing queries DoCmd.RunSQL
  18. VBA to copy a file from one directory to another
  19. Export each sheet to a separate csv file
  20. excel vba- extract text between 2 characters
  21. Round function in Excel, worksheet function vs VBA
  22. What is behind this difference in parentheses effect in VBA?
  23. Count the number of rows in another sheet [duplicate]
  24. Working with Unicode file names in VBA (using Dir, FileSystemObject, etc.)
  25. Search structured text in Outlook body
  26. VBA Password Input with Cancel Function
  27. What does the $ symbol do in VBA?
  28. Does the bitness of the OS ever matter, or is it just the application I need to worry about?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment