Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  Deactivate status message - VBA

    Posted 05/09/11 10:47 AM

    Originally posted by: BL_G


    Hello,

    how can I deactivate the status message after an optimization in Excel VBA?

    Thanks,
    Bernard
    #CPLEXOptimizers
    #DecisionOptimization


  • 2.  Re: Deactivate status message - VBA

    Posted 05/09/11 12:56 PM

    Originally posted by: SystemAdmin


    Are you talking about the status message that displays the solution and asks you whether to replace the original values in the variable cells?
    This message cannot be deactivated when using the GUI.
    When using VBA macros the message can be avoided using the NoDialog argument to CPXsolve (see file cplexvba.bas in the Excel examples directory).
    #CPLEXOptimizers
    #DecisionOptimization


  • 3.  Re: Deactivate status message - VBA

    Posted 05/10/11 07:59 AM

    Originally posted by: BL_G


    Hello Daniel,

    great, thanks.

    Bernard
    #CPLEXOptimizers
    #DecisionOptimization