Forced garbage collection

Question

Is there a way to force garbage collection in VBA / Excel 2000?

This question relates to macro language in Excel. Do not use VB.NET to manage Excel. So GC.collect () will not work

Answer 1

You cannot use the garbage collection provided by the .NET Framework when using direct VBA. Perhaps this article by Eric Lippert will be useful

Answer 2

VBA/Excel , VB. GC . , ( ). VB, , .

Answer 3

GC VBA, Nothing .

, kd7, , , , .

VBA , , Excel, , , VBA, .

Set O = Nothing, O , , .