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