title: CPLEX OPL and Excel VBA Integration
body: <p>I have to run the same optimization model many times with different parameters for research purposes. (I am trying to observe the results I'll get off a single model when I increase a parameter) The easiest way for me to do is to use Excel Macros as it would take me forever to solve each model one by one and record the results. However I have no idea how I will make VBA call the CPLEX Solver and read all my parameters from my excel sheet and write the results back there.</p>
  
  <p>If I am to put what I want to do in steps in VBA, it'd be something like so:</p>
  
  <ol>
  <li>Increase the parameter by x (This parameter is being read by CPLEX -but i don't know the VBA code for that-)</li>
  <li>Solve the model using the new value for x.</li>
  <li>Write all results back to the Excel sheet (using VBA codes, once again)</li>
  <li>Repeat all steps by k times.</li>
  </ol>
  
  <p>So to sum it all up I'd be really happy to know how I can,</p>
  
  <ol>
  <li>Integrate VBA and CPLEX</li>
  <li>VBA codes for making CPLEX read from my Excel sheet.</li>
  <li>VBA codes for making CPLEX write to my Excel sheet.</li>
  </ol>
  
  <p>Thanks in advance.</p>
  
  <p>Note: I tried reading all of the troubleshooting + CPLEX guides to help me on this issue but it confused me even more.</p>