Add help text to custom functions in Excel

[jim4u]

Hi gurus,

I have an automation add-in created using C# for Excel, in which I am
exposing a number of functions. Is there any way I can add help-text
the way excel does for other categories like Financial, Statistical,
etc.

The place I want my help-text to be available is in the
Insert->Function. Here, we can select a category and function. The
corresponding help text is displayed. Now, my automation add-in is
also listed in this categories. I want help text to be displayed when a
user selects my add-in and functions in it.

I tried the MacroOptions method, but it is raising an exception.

This is the code I tried (I tried both early binding and late binding):

early binding:

code:

_excelApplicati on.MacroOptions ("Report_Alloc" , "custom description",
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, "Report.Report" , Missing.Value,
Missing.Value, Missing.Value);

Exception Message: "Exception from HRESULT: 0x800A03EC."
StackTrace " at
Microsoft.Offic e.Interop.Excel ._Application.M acroOptions(Obj ect Macro, Object
Description, Object HasMenu, Object MenuText, Object HasShortcutKey, Object
ShortcutKey, Object Category, Object StatusBar, Object HelpContextID, Object
HelpFile)\r\n at .......

late binding:

code:

object[] parameters = new object[10];
parameters[0] = "Report_All oc";
parameters[1] = "Some sample description..." ;
parameters[2] = Missing.Value;
parameters[3] = Missing.Value;
parameters[4] = Missing.Value;
parameters[5] = Missing.Value;
parameters[6] = "Report.Report" ;
parameters[7] = Missing.Value;
parameters[8] = Missing.Value;
parameters[9] = Missing.Value;

_excelApplicati on.GetType().In vokeMember("Mac roOptions",
BindingFlags.In vokeMethod | BindingFlags.Pu blic | BindingFlags.In stance,
null, _excelApplicati on, parameters, new
System.Globaliz ation.CultureIn fo("en-US"));

Exception Message: "Exception has been thrown by the target of an invocation."
StackTrace " at System.RuntimeT ype.InvokeDispM ethod(String name,
BindingFlags invokeAttr, Object target, Object[] args, Boolean[]
byrefModifiers, Int32 culture, String[] namedParameters )\r\n at
System.RuntimeT ype.InvokeMembe r(String name, BindingFlags invokeAttr, Binder
binder, Object target, Object[] args, ParameterModifi er[] modifiers,
CultureInfo culture, String[] namedParameters )\r\n at ......
Inner Exception Message: "MacroOptio ns method of Application class failed"
Any help would be appreciated.... .
Jim
work smart, not hard!