profiling an excel add-in

Code and memory profiling for .NET developers.

profiling an excel add-in

Postby fulmerspot » Wed May 20, 2009 5:00 pm

I have developed an excel add-in which uses the excel COM automation addin functionality to create user defined functions. The add-in uses managed code (C#) shimmed to present a COM interface to excel. The user-defined functions perform multi variate optimisations which take several seconds to execute, I wish to optimise these but cannot get the profiler working. Has anyone else used the profiler on automation addins for excel?

Posts: 1
Joined: Wed May 20, 2009 4:55 pm

Postby Brian Donahue » Fri May 22, 2009 12:52 pm


I think that what you describe is true for any Office add-in. DTE is implemented as COM and managed add-ins are registered as COM objects using a tool like regasm.

The instructions for profiling Office add-ins are on our website: ... 000224.htm

If you have a specific problem, please email and provide as much detail as possible.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to ANTS Profiler Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests