Accessing excisting Excel 2003 UDFs from a .net Addin

[Steve Price]

Hi!

We're developing an addin for excel 2003 in C# 2.0 which contains some User
Defined Functions, and we need to call excisting excel functions provided by
a different addin (COM automation). What is the best way of calling these
functions?

Kind Regards,

Steve Price

 

[Bob Eaton]

via COM?

Is there another way?

Bob

 

[Steve Price]

Sorry let me clarify,

We are making a COM automation addin, how do you call a built in excel
function like SUM?

I tried using Application.Run, to no avail.

Thanks

Steve

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?U3RldmUgUHJpY2U=?=,

We are making a COM automation addin, how do you call a built in excel
function like SUM?

I tried using Application.Run, to no avail.

Try Application.WorksheetFunction for the built-in functions. (I'm a bit
confused as to what you really want, since you mention SUM here, but UDF
in your subject line).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Steve Price]

Hi Cindy!

Thanks for solving as to how to access the inbuilt worksheet functions for
me, but as you guessed by my title, that was only part one of my problem.

Do you know how to go about accessing the UDFs in excel, such as those
provided by an XLL addin?

The IWorksheetFunction interface of course contains only interfaces for the
inbuilt functions.

Thanks,

Steve

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?U3RldmUgUHJpY2U=?=,

Thanks for solving as to how to access the inbuilt worksheet functions for
me, but as you guessed by my title, that was only part one of my problem.

Do you know how to go about accessing the UDFs in excel, such as those
provided by an XLL addin?

No, sorry... I think I saw it discussed once, but no details stayed in my
Word-centric brain. Best place to ask this is in the excel.programming
newsgroup. In order to not scare anyone away , just ask how to access UDFs
from a COM Addin (don't mention .NET). You might also provide the target
version number of Excel and exactly in what form these UDFs are provided to
the Excel application.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Steve Price]

Ok will do, thanks Cidny,

Steve

Hi =?Utf-8?B?U3RldmUgUHJpY2U=?=,

No, sorry... I think I saw it discussed once, but no details stayed in my
Word-centric brain. Best place to ask this is in the excel.programming
newsgroup. In order to not scare anyone away , just ask how to access UDFs
from a COM Addin (don't mention .NET). You might also provide the target
version number of Excel and exactly in what form these UDFs are provided to
the Excel application.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail