jbravo223
asked on
Memory MGMT in Excel VBA ???
How do I clean up memory in Excel VBA? I've tried setting objects to "Nothing" but I get an error stating that this is an invalid use of an object.
My VBA Macro calls a third party API which returns numerous strings that are huge in size. The Excel workbook end up taking up 60-80 mb of RAM. How can I get excel to release all objects?
My VBA Macro calls a third party API which returns numerous strings that are huge in size. The Excel workbook end up taking up 60-80 mb of RAM. How can I get excel to release all objects?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.