Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.

 View Only

  • 1.  Excel vba and cplex

    Posted Wed May 05, 2010 07:01 PM

    Originally posted by: jzhou


    Is it possible to call cplex dll in Excel VBA
    I am interested to solve some big MIP problems in Excel.
    Alternatives are Previum Solver as Excel Add-on.
    But i like to try cplex.

    Thanks in advance for the reply...

    Jeff
    #CPLEXOptimizers
    #DecisionOptimization


  • 2.  Re: Excel vba and cplex

    Posted Thu May 06, 2010 05:24 AM

    Originally posted by: SystemAdmin


    What CPLEX version do you use? Have you tried the CPLEX Excel connector? It offers functionality similar to the builtin solver and also VBA functions/macros.
    #CPLEXOptimizers
    #DecisionOptimization


  • 3.  Re: Excel vba and cplex

    Posted Thu May 06, 2010 02:24 PM

    Originally posted by: SystemAdmin


    Just in case it adds clarity, please note that the CPLEX connector for Microsoft Excel is available in CPLEX version 12.
    #CPLEXOptimizers
    #DecisionOptimization


Related Content