VBA and Simul8 COM - issue with reading from excel
I am trying to get Excel VBA and SIMUL8 COM to automate running a number of trials.
The VBA is opening the SIMUL8 model and associated Excel workbook that stores all of the model inputs.
Then I use the S8SimulationOpened event to call the VL function which reads the inputs from the, now open, Excel input book into SIMUL8.
The following steps are to use VBA to run a trial, save the outputs, etc.
The problem being that SIMUL8 keeps giving the error "EXCEL... is not responding to a conversation request" and so doesn't seem to be able to communicate with another Excel workbook.
Has anyone else had this issue and found a way to get around it...?
Any help is much appreciated!