Access Excel Solver from a C# Add-in

[Guest]

I'm a novice, so go easy on me. =)

I'm trying to learn C# by writing an Excel Add-in that back tests stock
trading strategies. It's more of a financial toy than a real power-house.
I'm using VS2005, VSTO for '03/'07, and running Excel 2003.

Because I am doing this for a class, one requirement is to incorporate
optimization. I figure if I could access Excel Solver, I would be able to do
much better calculations. I've written a good portion of the add-in, but I'm
realizing that accessing Excel Solver from C# is very hard to research.

Are there any MSDN articles on this? It seems Solver is only exposed to
VB.Net; how can that be?

Thanks in advance!

 

[Guest]

*bump*
I don't mean to be annoying, but there is seriously no documentation
anywhere about getting to solver from C#. How could MS expose functionality
to VBA/VB.Net and not to C#?