Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  running a cplex project from a macro in excel

    Posted 06/03/13 05:54 PM

    Originally posted by: jaunfra


    hi, 
    Im using ILOG CPLEX 12.5 It is possible to run a project (o write a project and then run it) using a macro and VBA of Excel 2013?? 

    i now that there is also the add-in for Excel, but in Excel 2013 it doesnt work....

    Need help to run the Project in some way using a macro, i been considering to move the pointer of the mouse and click the play button of CPLEX to run it...

    Thank You

    Jaunfra


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: running a cplex project from a macro in excel

    Posted 06/05/13 12:10 PM

    Hi,

     

    maybe you could have a look at the examples that are in CPLEX_Studio125\cplex\examples\src\excel

     

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: running a cplex project from a macro in excel

    Posted 01/01/14 12:18 AM

    Originally posted by: m.dehghani86


    Hi Alex

    I'm really Confused, I'm trying to figure out how add CPLEX to VBA but it doesn't work.

    I did everything you told me, I imported cplexvba.bas and also Example1.bas to VBA, but when I run it, it shows an error which can not read cplexvba Subs like: CPXclear(), or CPXupdateVariable() ant etc.

    please explain me what's wrong with it?  

    also when I want to run a VB.net example, the green RUN button is disabled? why?

    thanks

     

     


    #DecisionOptimization
    #OPLusingCPLEXOptimizer