Originally posted by: islaabdi

Hi everyone,

I'm actually using cplex to solve a optimization problem (Markowitz optimization). And I have an error that I couldn't solve. Here the value of the cell where I had the error :

ActiveCell.Offset(0, 1).Formula = "=MMULT(" & Comp.Address & "," & "MMULT(" & Mat.Address & "," & CompBis.Address & ")" & ")" where Comp,Mat and CompBis are ranges.

 But when I use cplex via the ADDINS of excel it solved my optimization problem with no error.

Thanks for your response,

Ismail

Hi,

are you aware of

http://www-01.ibm.com/support/knowledgecenter/SSSA5P_12.6.3/ilog.odms.studio.help/CPLEX/ReleaseNotes/topics/releasenotes125/convertExcelDeprecated.html

?

You have a Markowitz example at

CPLEXStudio1263\opl\examples\opl\models\Portfolio

regards

Originally posted by: islaabdi

No I wasn't aware of this information. Thanks for the link. But you think there is no solution for this error ?