|
Hi,
I am writing an add-in for MS Excel. Upon installation the Add-in adds excel cell formulas (User Defined Functions) in a category. It also adds menu items to the Excel. Here are the technical details of the development:
-- Using Shared Add-in (under Extensibility) project under VS .net 2005. Select only "Microsoft Excel" in the "Select an Application Host" step of the Add-in wizard.
-- Language - C#
The project creates the file Connect.cs with GuidAttribute. Looks like this:
[GuidAttribute("E79BD972-0295-420E-8E42-038685177BDF"), ProgId("MyAddin1.Connect")]
public class Connect : Object, Extensibility.IDTExtensibility2
To add additional User Defined Functions (UDF), I add public functions in the above connect class like this:
public string ExecuteQuery(System.String strQuery, [Optional] object optionalServerIp, [Optional] object optionalPort, [Optional] object optionalPollInterval)
{
//start processing here asynchronously
return "Executing...";
}
In order to add this function as excel cell function I create an entry in the registry like this:
HKEY_CLASSES_ROOT\CLSID\{E79BD972-0295-420E-8E42-038685177BDF}\Programmable
where Programmable is the key that is created (no value).
After installation (which can be done just by building on the developer machine or by creating a setup project using vs), the cell function can be called using the function wizard as follows:
Open the Insert Function wizard by clicking on the fx button in the function bar.
Select the newly added category "MyAddin1.Connect" and select the function "ExecuteQuery" under it. This will open up a Function Arguments dialog like this -
<image here>
What I want to do (and not able to figure out) is -
-- Replace the text "No help available" with my function description on ExecuteQuery.
-- Display the parameter help. "StrQuery" in the lower half should be displayed as "StrQuery is the text string which represents a query"
-- Help on this function should be linked to some file (ex. .chm file).
Please let me know if there is some way to achieve the above. Its a little urgent for me and I am stuck on this.
Pls let me know if you need any other details to assist you.
Thanks,
Sudhakar,
Pune, India
9890874053
|
