S
shailendrap
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 -
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,
Shailendra
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 -
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,
Shailendra