Originally posted by: SystemAdmin

[jwbeanbrain said:]

I've been told that the VBA code that worked in OPL Studio 3.7 no longer works in 5.5, so I've been using the shell command to run solver. Shell command (Command = Shell("oplrun.exe -f "....)) doesn't give me any error capturing or any way to manage the solve.

What is the recommended method to reference OPL Studio with VBA code at this point?


#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[vblanchard said:]

If you call OPL from a MS Office application, then it is recommended to use a .net language and Visual Studio Tools for Office (cf Release Notes and Migration Guide > New and changed in OPL 4.0 > The libraries > The .NET API)


#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[alain.chabrier said:]

Note that this support of MS Office integration with OPL is following Microsoft recommendations.
#DecisionOptimization
#OPLusingCPLEXOptimizer