View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen Stephen Bullen is offline
external usenet poster
 
Posts: 67
Default C# (sharp) and Excel

Hi Ludwig,

I am learning some C# and I wonder if I can create dll fiels to be
used in Excel. I saw others post on DLL and tried out a few things
but was not able to make it work. They are al financial functions.

I did:

Go to Excel and declare the functions and also load them up as a
reference.

BUt it did not work.

any help would be appreciate it.


Really the only way to do it is to expose your functions in a COM
Class, then use those from Excel (by adding a reference to that class
and Tools References or using 'Automation Addins'). If you search
the .Net help for "COM Class" (no quotes), you should see a C# example
of both client and server. Once you've built that, search again for
'Automation Addin' and you should find an example of how to use it in
Excel.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk