Forcing Garbage Collection
excel, excel-2000, vba
Solution
You cannot take advantage of garbage collection provided by the .NET Framework when using straight VBA. Perhaps this article by Eric Lippert will be helpful
Problem
Is there a way to force garbage collection in VBA/Excel 2000? This question refers to the Macro language in Excel. Not using VB .NET to manipulate Excel. So GC.collect() won't work