Announcement

Collapse
No announcement yet.

VBA call for solver

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • VBA call for solver

    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

  • #2
    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.

    Comment


    • #3
      Also see
      http://support.microsoft.com/default...ver/solver.asp
      for a good introductory tutorial on using Solver in code.
      Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

      Comment


      • #4
        VBA call for solver

        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

        Comment


        • #5
          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
          Kind Regards, Will Riley

          LinkedIn: Will Riley

          Comment


          • #6
            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

            Comment

            Working...
            X