Excel xll 可用于跟踪进行了哪些 VBA 和其他插件调用、花费的时间和使用的内存？
我以前在某个地方工作过，他们有一个 xll，允许人们跟踪 Excel 中使用的内存量。此外，当调用其他 dll 和 xll 时，这些也会被记录下来。这一切都被输出到基于 Excel PID 的日志文件中。然后有一个解决方案可用于将日志读取为可在数据透视表中使用的格式。
我已经用谷歌搜索了近一个小时，从各个角度搜索它，但我只是没有任何运气。我不记得提供者，但我很确定它不在内部。
希望人们能够提供帮助。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
没有回应。那好吧。
最终我设法找到了答案。它是一个称为性能监视器的实用程序。这里讨论的是：
http://www.dailydoseofexcel.com /archives/2007/09/18/performance-monitor/
它来自《专业 Excel 开发》一书：
专业 Excel 开发：使用 Microsoft Excel、VBA 和 . NET：...和 VBA（Addison-Wesley Microsoft 技术）的权威指南
我希望这对未来寻找此内容的人有所帮助。
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.