Using Excel Solver in VB with no cell references?
I am writing some visual basic code to solve for a solution. In the end I want it to optimize the solution through iterative method which is exactly what the Excel solver does. However I need it in pure VB. The Excel solver relies 开发者_如何转开发on cell references which does not work for me :(
My problem has 6 parameters and 1 value to minimize.
Help will be greatly appreciated.
You cannot use the solver without cell references - you'll have to put the info into cells and then call it.
精彩评论