Can Excel Solver tool be used in VB.NET app?

[KerryC]

Where I work we have an excel spreadsheet that uses the Solver add-in tool to determine the best values for 4 variables based on 4 equations. Some of the other variables (those we measure) are already entered into a db applicaiton we all use, and if possible I want to create a VB.NET application that can be called from the db appliclication, solve for the unknown variables and pass them back.

Is it possible to use the Solver tool from withing a VB.NET application?

Cheers,
Kerry

 

[chiph]

Most likely, yes.
However, all the users of your app will need to have a legally licensed copy of Excel.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first