Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: VBA call for solver

  1. #1
    Join Date
    13th August 2004
    Posts
    183

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709
    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.

  3. #3
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,302
    Also see
    http://support.microsoft.com/default...ver/solver.asp
    for a good introductory tutorial on using Solver in code.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    13th August 2004
    Posts
    183

    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

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,677
    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

    Web Presence:
    Personal: Datasapien
    LinkedIn: Will Riley

  6. #6
    Join Date
    13th August 2004
    Posts
    183
    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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Call Function At Each Iteration Of Solver
    By Alastor in forum EXCEL HELP
    Replies: 4
    Last Post: December 10th, 2013, 15:57
  2. Solver Macro Without Solver Result Dialog
    By ash2005 in forum EXCEL HELP
    Replies: 1
    Last Post: October 10th, 2007, 22:01
  3. Multiple Solver Constraints in Solver
    By simonsays in forum EXCEL HELP
    Replies: 12
    Last Post: September 13th, 2006, 12:26
  4. Call to Excel SOLVER gives 424 in a VBA Macro
    By ozono27 in forum EXCEL HELP
    Replies: 6
    Last Post: September 13th, 2005, 14:45
  5. Solver Or Vba ?!
    By Michael Avidan in forum EXCEL HELP
    Replies: 19
    Last Post: July 1st, 2004, 14:57

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno