I worked somewhere before where they had an xll that allowed one to track the amount of memory being used in Excel. Also when calls were made to other dlls and xlls these were logged. This was all spewed out to a logfile based on the Excel PID. There was then a solution that could be used to read the log into a format that could be used in a Pivot Table.
I have googled for nearly an hour coming at it from all angles in search terms, but I am just not having any luck. I cannot remember the provider but I am pretty sure it wasn't in house.
Hope people can help.
No responses. Oh well.
In the end I managed to find the answer. It is a utility called Performance Monitor. It is talked about here :
http://www.dailydoseofexcel.com/archives/2007/09/18/performance-monitor/
It is from the book Professional Excel Development :
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)
I hope this helps future people searching for this.