Using .NET objects in Excel

Question

Is there a way to use .NET objects in Excel?

I have seen people using COM classes created using VB6 in Excel. So, I wonder if we can use .Net objects? (without turning them into COM objects)

Answer 1

2 cases

Do you want to access a .NET object created from Excel VBA

The .NET component is required to be registered for COM interoperability.

You want to access a .NET object created from a .NET.NET application

Use Visual Studio Tools for the Office System to create workbooks and objects all in one place. Very easy.

http://msdn.microsoft.com/en-us/vsto

Some More Useful Links on How to Create COM Interop Assemblies

fooobar.com/questions/1346305 / ...

Very detailed summary of COM Interop inputs and outputs with .NET

Effectively, once you recognize the style, you can quickly create, edit, and distribute .NET assemblies that you can directly access using Office clients.

Hope this helps