profiling an excel add-in

Code and memory profiling for .NET developers.

Moderators: Brian Donahue, richardjm, StephenC

profiling an excel add-in

Postby fulmerspot » Wed May 20, 2009 6: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?

Thanks.
fulmerspot
 
Posts: 1
Joined: Wed May 20, 2009 5:55 pm

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

Hello

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:

http://www.red-gate.com/supportcenter/C ... 000224.htm

If you have a specific problem, please email support@red-gate.com and provide as much detail as possible.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to ANTS Profiler Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests