开发者

Excel xll that can be used to track what VBA and other addin calls have been made, time spent and memory used?

开发者 https://www.devze.com 2023-02-13 01:13 出处:网络
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 spewe

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开发者_StackOverflow 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.

0

精彩评论

暂无评论...
验证码 换一张
取 消