VSTO: calling excel funcions?
 

How do I call funcions in my own add-in from C# using VSTO 2003?
Regards
Lars Schouw

calling excel funcions?
 

Lars

More in hope than expectation as I am only skimming VSTO at the present (and
even then in VB.Net not C#), but if you have a pointer to the Excel
application object through the Office Interop structure then you should be
able to use the WorksheetFunction property of the Application object

xlApp.WorksheetFunction.Min(Range)

Note: Some functions are not available through this route for a list check
help in VBA for the property

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Lars Schouw" wrote in message
oups.com...
How do I call funcions in my own add-in from C# using VSTO 2003?
Regards
Lars Schouw

calling excel funcions?
 

Thanks Nick
How about by own VBA add-in functions like e.g.
=ChineseNewYear(1/5/2005) from my own add-in holidays.xla

Regards
Lars Schouw

calling excel funcions?
 

I just found it you can use Application.Run( .... )

Runs a macro or calls a function.

Lars

calling excel funcions?
 

Lars

Sorry didn't realise it was a UDF. You have the correct route to run any
code in Excel now...good luck

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Lars Schouw" wrote in message
oups.com...
I just found it you can use Application.Run( .... )

Runs a macro or calls a function.

Lars