I have a cyclic stochastic sechduling problem. I am going to use some optimization software (such as GAMS, CPLEX) to get a optimal scheduling of jobs with deterministic processing time, then, I will transfer such schedule to simul8 to test if the schedule is robust enough if the job processing time is stochastic. After the simulation, I need to transfer data to optimization software again to have new optimal schedule, and so on and so forth, up to 100 cycles.
How can I realize this? Shall I use VBA-Excel or VB to control?