UDF FOR EXCEL 2003 USING VSTO 2005 SE.

parmanu

hi guys
i am pretty new to vsto 2005 SE.
i have created a add-in using VSTO 2005 SE.
i want to write a user defined function say Add(int,int).
when we write in the cell =Add(1,2) this will return us the sum.
i want to ask where this Add function will be declared and what other refrences are required.
i want to know how UDF are used and declared .
please enlighten with the above example if possible.
otherwise give idea in steps.
plzz help me.

Cindy Meister

See this message thread

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=426211&SiteID=1

parmanu

hi thanks
but this could not solve my problem.
when we create add-in using vsto 2005 SE we get two methods as:

private void ThisAddIn_Startup(object sender, System.EventArgs e)
and
private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
so dont have method with name : ThisWorkbook_Startup.
when i write below
ThisApplication.Run ("CallbackReg", new MyUdf());
in ThisAddIn_Startup .
this gives error.
so please tell me all this in refrence to above ThisAddin_startup and _shutdown methods.
please guide me in same way as a sample given in
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=426211&SiteID=1

parmanu

Hey guys
if somebody can make efforts to
help me plzz.

Dennis Wallentin

Hi parm,

With all the respect to VSTO but it simple lacks the basic to work with UDF in Excel (at least in the present version).

Use the following approach by Eric Carter:

Writing user defined functions for Excel in .NET:
http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx