ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Access Excel Solver from a C# Add-in (https://www.excelbanter.com/excel-programming/388083-access-excel-solver-c-add.html)

Mr.BlueSummers

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!

Mr.BlueSummers[_2_]

Access Excel Solver from a C# Add-in
 
*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#?


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com