Originally posted by: story_

Hey there everybody,

This is a very simple question however I am not sure what I am supposed to do. So basically, I am using CPLEX OPL Version 12.4 and Excel 2007 on a Windows 7 64-bit laptop. 

I need to solve multiple models in CPLEX with different parameters to observe a pattern in my model. To do this, instead of solving the models one by one (I need to solve around 200 models with different parameters) I am willing to write a code on Visual Basic to do it for me. I am clueless of which add-ins I shall use and which codes I should utilize.

The basic steps I want my code to do is:

1- After increasing the parameter make this excel file the document that is used in my optimization model.
2- Run the optimization model. (The model takes parameters from the excel file and writes the results to the same excel file)
3- Export the excel file
4- Copy the results and paste them in another Excel document where all results for different parameters are kept.

I would be really happy if you could help me with this very simple problem.

Thanks in advance.

 

Hi

have you had a look at

https://www.ibm.com/developerworks/community/forums/html/topic?id=5af4d332-2a97-4250-bc06-76595eef1ab0&ps=25

?

regards

Originally posted by: story_

Hey there,

Thank you for your post.

The situation is pretty similar, though in my case I'm willing to use Excel Macros and a single cell where the parameter is kept. I am willing to increase the parameter using a For loop in Excel Visual Basic, within the same loop I was thinking of solving the model and executing the results in the same Excel document.

I am not quite sure how I will integrate Excel Visual Basic and CPLEX. I couln't find VBA codes to command Cplex to solve and execute results to an Excel file. In addition I am almost sure that I have to use an add-in (which I learned via the CPLEX Help Guide) however Excel gives an error which says that the add-in is invalid and could not be used.

Thanks for your support.

Hi

Are you ok to use VSTO

?

http://www-01.ibm.com/support/knowledgecenter/#!/SSSA5P_12.3.0/ilog.odms.ide.help/Content/Optimization/Documentation/Optimization_Studio/_pubskel/ps_opl_Interfaces1214.html

Originally posted by: story_

Hello,

I have seen this article before, however I am not so familiar with VSTO. That's why I was wondering how to work on Excel Visual Basic.

Thanks

Hi

well VSTO uses VB

With VBA you may have a look at

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014880109

regards

Originally posted by: story_

Hello,

Well I'm completely new to VSTO so I don't know any of the codes that come with it, for now all I can do is to look them up. I just have a very basic knowledge on VBA.

I have read the user's manual on the Excel add-in before. I'm using CPLEX OPL version 12.4 and mine came with the add-in file already. My system is x86 and the add-in file is just incompatible with my Excel 2007 somehow. It gives an error where it says the file is not valid. Once I solve this issue I will try using the codes in the link you have sent. 

Thanks