Originally posted by: jaunfra

Hi all:

im using cplex and arena software for my master thesis but im having problem to try to integrate this two softwares.

is this possible to do by a callable library?

thank you!

I don't know "arena" but according to this post it seems like it is possible to integrate the callable library with arena. Maybe you can get in contact with the author of the quoted post.

There also is this paper that could be helpful

@article{Vamanan:2004:ICS:971894.971898,
 author = {Vamanan, Mayur and Wang, Qian and Batta, Rajan and Szczerba, Robert J.},
 title = {Integration of COTS software products ARENA \& CPLEX for an inventory/logistics problem},
 journal = {Comput. Oper. Res.},
 issue_date = {April 2004},
 volume = {,
 number = {4},
 month = apr,
 year = {2004},
 issn = {0305-0548},
 pages = {533--547},
 numpages = {15},
 url = {http://dx.doi.org/10.1016/S0305-0548(03)00010-8},
 doi = {10.1016/S0305-0548(03)00010-8},
 acmid = {971898},
 publisher = {Elsevier Science Ltd.},
 address = {Oxford, UK, UK{31}31},
 keywords = {simulation and optimization, software integration, supply chain applications},
}

Originally posted by: jaunfra

Thanks Daniels
I have read the paper  actually but i need like an example to see how is the integration done and then prepare the code, i will try to contact the author of the post.
Thanks again for your time to answer this post!

Originally posted by: m.dehghani86

Hello

have you got any word from the author?

if you know how you can call cplex in arena please let me know

Thanks

Originally posted by: Alrezq

Hi, 

It has been a while since you wondered how to integrate Arena with CPLEX. have you found the method on how to do so. 

Thank you 

Hi

you could use loose coupling if you can use VBA:

For example, in a button I wrote:

Private Sub Button1CallOPL_Click()
MsgBox "Externall call"

Dim strPath As String
strPath = "C:\ILOG\CPLEX_Studio126_32\opl\bin\x86_win32\oplrun.exe C:\ILOG\CPLEX_Studio126_32\opl\examples\opl\oil\oil.mod C:\ILOG\CPLEX_Studio126_32\opl\examples\opl\oil\excelbuttonoilSheet.dat"

    Shell strPath

End Sub

Then from VBA you can call any OPL model

regards