VBA call for solver

[ie_nyp]

Dear all,
Are there any code that can call solver to work in VBA? For example, I create a button and once press it, it can solve the problem?
Thx

[Dave Hawley]

Hi ie_nyp

If you do a forum seach on "Solver" you will find quite a bit. The other way is to Record a macro while setting it up.

[Derk]

Also see
http://support.microsoft.com/default...ver/solver.asp
for a good introductory tutorial on using Solver in code.

[ie_nyp]

Hi all,
I have tried to record the macro to use run the solver once I press the command button, however, it won't work, are there any coding can replace that?
Thx

[Will Riley]

What is your current code & what is going wrong.

Also, you may want to check out this site

http://www.solver.com/suppstdvba.htm

Also, please do not start new threads unnecessarily... I have merged them so that people don't waste their time looking at duplicates.. Thanks

[ie_nyp]

Sorry for that mistake,
my problem is that once I have reset the solver, the assumption of "using linear program" and " the result has non-negative value" has removed. How can I reset the solver and at the same time set back this two values>?
Cheers