Memory management of Excel application

[jordan2322]

Hi Guys,

I am having issues with the Memory usage of the excel application from running my macros.

These macros gets data from a mySQL database, builds abd populates custom class objects, and stores them in scripting dictionaries.

I have multiple scripting dictionaries and do not know where to start looking for the culprit(s) that are not being cleared with each run of my macros: Is there any way I can determine which the memory size of a scripting dictionary to help me locate where to make changes to my code base?

Kind regards
Jordan