Originally posted by: BL_G

Hello,

just a general question to the Excel VBA CPLEX Optimizer: Is it possible to read in arrays instead of ranges?

Thank you,
bernard
#CPLEXOptimizers
#DecisionOptimization

Originally posted by: SystemAdmin

> just a general question to the Excel VBA CPLEX Optimizer: Is it
> possible to read in arrays instead of ranges?

The functions in cplexvba.bas seem to only accept ranges. You could
use VBA to convert arrays to/from ranges and then proceed using the
functions.
#CPLEXOptimizers
#DecisionOptimization

Originally posted by: BL_G

Thank you for your answer. How would it work for the output of CPLEX? I typically have to provide a range to let CPLEX know where to write down the values.

The reason why I am asking is that it normally takes quite a time for VBA to access worksheets. Arrays function a lot faster.

Thanks!
#CPLEXOptimizers
#DecisionOptimization

Originally posted by: SystemAdmin

> How would it work for the output of CPLEX? I typically have to
> provide a range to let CPLEX know where to write down the values.

The Excel connector will update the values of the cells that have been declared as the variable(s) or the objective function as the optimization process occurs. If the solve was successful, the final values of those cells represent the optimal solution.

> The reason why I am asking is that it normally takes quite a time
> for VBA to access worksheets. Arrays function a lot faster.

I will not be able to speak to this, but it looks like the current design requires ranges.
#CPLEXOptimizers
#DecisionOptimization