implementing help for UDF
 

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

implementing help for UDF
 

Try this:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
| 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
|

implementing help for UDF
 

Hi

This link is for VBA, as I mentioned I am writing UDF's in C# .Net.

Thanks
Shailendra

On May 10, 3:02 pm, "Niek Otten" wrote:
Try this:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in oglegroups.com...

| 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
|

implementing help for UDF
 

Hi,

This link is for VBA, as I mentioned I am writing UDF's in C# .Net.

I think the book Professional Excel Development will prove useful for
this, it has a chapter on xll's and C#.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com