Topic
  • 2 replies
  • Latest Post - ‏2014-01-01T05:18:29Z by m.dehghani86
jaunfra
jaunfra
4 Posts

Pinned topic running a cplex project from a macro in excel

‏2013-06-03T21:53:58Z | cplex excel library macro vba

hi, 
Im using ILOG CPLEX 12.5 It is possible to run a project (o write a project and then run it) using a macro and VBA of Excel 2013?? 

i now that there is also the add-in for Excel, but in Excel 2013 it doesnt work....

Need help to run the Project in some way using a macro, i been considering to move the pointer of the mouse and click the play button of CPLEX to run it...

Thank You

Jaunfra

  • AlexFleischer
    AlexFleischer
    2307 Posts

    Re: running a cplex project from a macro in excel

    ‏2013-06-05T16:10:28Z  

    Hi,

     

    maybe you could have a look at the examples that are in CPLEX_Studio125\cplex\examples\src\excel

     

    regards

  • m.dehghani86
    m.dehghani86
    7 Posts

    Re: running a cplex project from a macro in excel

    ‏2014-01-01T05:18:29Z  

    Hi,

     

    maybe you could have a look at the examples that are in CPLEX_Studio125\cplex\examples\src\excel

     

    regards

    Hi Alex

    I'm really Confused, I'm trying to figure out how add CPLEX to VBA but it doesn't work.

    I did everything you told me, I imported cplexvba.bas and also Example1.bas to VBA, but when I run it, it shows an error which can not read cplexvba Subs like: CPXclear(), or CPXupdateVariable() ant etc.

    please explain me what's wrong with it?  

    also when I want to run a VB.net example, the green RUN button is disabled? why?

    thanks