Function with VSTO ?

[[email protected]]

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

[Simon Murphy]

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