There is a thread out there that already discusses a little of it:
Integrate C++ program into VBA - QuantNetwork - Financial Engineering Forum
Are you asking because this is something you have to do? Also, do you want to use C# as a replacement for VBA macros, or do you want to call the Excel object model from a C# program? Those are totally different issues.
Joe, thanks. What I mean is integrated C# and Excel (not C++, it is C#).
Secondly, I want to know how call C# object model from Excel and vice versa.
I've had so much trouble with putting .NET on top of Excel, that I would not recommend it. For me it worked fine up to a point, but once I started doing a large amount of calculations/cell changes things would bog down and eventually would crash Excel. It got to be so much trouble that I gave up and ported it to be a stand alone VB .NET program. Things work great now, and it really didn't take that much more programming.
Looks nice Andy. I just want to add my opinion on Excel and .NET intergration (I know it might looks like an ad but I believe this information might be really usefull to visitors of this forum and could save them a lots hours of programming).Have fun. Keep in mind that I tested it with VS2008 Team edition and Excel 2007.
Looks like some interesting examples on how to utilize Excel object model from desktop applications, but from my experience most of the quants use Excel and .NET quite differently - Excel as a front end UI and .NET assemblies as a place to put calculation and other business logic, not the vice versa.Check with the following url , some useful c# excel help