profiling an excel add-in

fulmerspot

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.

Brian Donahue

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.