开发者

Using Excel Solver in VB with no cell references?

开发者 https://www.devze.com 2023-01-18 00:11 出处:网络
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 pu

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消