Is it possible to call .NET code from Excel 2007?

Question

I need to call some .NET code from Excel 2007, and I'm looking for a better way.

The official "Microsoft Approved Method" seems to include Visual Studio 2008 Professional, but I don't have one. I have VS2005, but plus VSTO 2005 SE can only run application-level add-ons, not document-level macros.

The problem is related to some analysis code that comes as .NET assemblies; I would like to manipulate it by changing some cells in an Excel worksheet.

Any other ideas?

Answer 1

You can expose .net objects to COM objects and then call them from VBA ...

The last message in this link contains the code:

http://bytes.com/groups/ms-access/205532-calling-c-net-dll-vba

Answer 2

Excel-DNA - .NET Excel. Excel, , . .NET 2.0 , VS 2005 .

( : Excel-DNA.)

Answer 3

() COM- VBA; ( ) DLL .. - DLL.

COM- DLL- .NET, VBA. VS2005, API- DLL.