Macro to clear Memory

[howard]

From time to time I have a macro to open up several workbooks and to run a macro to update these workbooks


Unfortunately, it uses a lot of RAM and occasionally the workbooks freeze and I need to close down Excel and restart Excel and re-run the macro


I would like to know if there is VBA code to clear the RAM after the macro has done what it is supposed to do.


If so kindly provide me with code to do so. If not is the any commercial software or freeware that can clear unused RAM ?

 

[howard]

must I put the code after end sub or before end sub ?

 

[shg]

I get user defined type not defined ...

You need to set a reference to Microsoft Forms Object Library: Tools > References ...., or add a userform, which you can then immediately delete.

 

[howard]

Thanks for your input


I am not that familiar with the Microsoft Forms Object Library

Please advise which items within the library I would need to select (Using office 2016)