Head (before)

VBA and Simul8 COM - issue with reading from excel — Simul8 Community Forum

Head (after)

Ask the Simul8 Community

Content (before)

VBA and Simul8 COM - issue with reading from excel

AlexRAlexR
Created at
in Community support

Hi all,

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!



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Attach file
Attach image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Content (after)