Hi,

In reading msdn webpages about Visual Studio Tools For Office 2003 I
see alot of info about handling events and creating winforms.

But I dont see anything about how to create an excel function in
csharp.

Anybody know if VSTO can be used to create new functions for Excel
which can be used within cells?

thanks,
Adam

Adam
yes you can create user defined functions in c#.
the best reference is Andrew Whitechapels book .net development for
Office.

This is seperate from VSTO. VSTO effectively turns office into smart
clients, where your .net app is the boss. For UDFs excel will be the
boss, so VSTO is not required. Also VSTO is 2003 only, C# UDFs will
work in 2k, xp and 2003.(They are Automation add-ins)

Using .net is pretty similar to COM or Automation add-ins ( as in
VB6).

Consider performance though, its expensive going across so many
interfaces, your c# code will need to be doing plenty of work to make
up.

cheers
Simon


--
Simon Murphy
------------------------------------------------------------------------
Simon Murphy's Profile: http://www.excelforum.com/member.php...o&userid=26538
View this thread: http://www.excelforum.com/showthread...hreadid=399723