|
Subject:
|
C# udf's in cell formulas
|
|
Posted By:
|
SteffenJ
|
Post Date:
|
8/15/2006 2:30:03 AM
|
Hi there.
I have some user defines functions in a C# dll that I would like to use in cell formulas in a VSTO project.
I can reference the dll and I can see the functions in the C# code but I can't use the functions in cell formulas.
I get #NAME? in the cell.
I could not find any samples in VSTO 2005 by Alvin Bruney - does any body have a sample?
Best regards
SteffenJ
|
|
Reply By:
|
alvinjohnbruney
|
Reply Date:
|
8/15/2006 1:50:54 PM
|
A couple things to check, make sure macros are enabled. Also, you need to make sure that the VBA code for hooking up the managed code world to the unmanaged world is in the code module for the target sheet. If you still can't get it working, here is a link that you may find useful. http://blogs.msdn.com/pstubbs/archive/2004/12/31/344964.aspx
|
|
Reply By:
|
SteffenJ
|
Reply Date:
|
8/18/2006 5:58:11 AM
|
Thank you for the answer.
But do I really have to use VBA in order to use C# functions in cell formulas?
I had hoped for a more direct way from C# to Excel using VSTO.
Best regards
SteffenJ
quote:
Originally posted by alvinjohnbruney
A couple things to check, make sure macros are enabled. Also, you need to make sure that the VBA code for hooking up the managed code world to the unmanaged world is in the code module for the target sheet. If you still can't get it working, here is a link that you may find useful. http://blogs.msdn.com/pstubbs/archive/2004/12/31/344964.aspx
|
