View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mr.BlueSummers Mr.BlueSummers is offline
external usenet poster
 
Posts: 1
Default Access Excel Solver from a C# Add-in

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!