Question
When using COM from Microsoft® Excel® to start a PTV Vissim simulation, I get the following message at the end: "Microsoft Excel is waiting for another application to complete an OLE action.". How can I avoid this message?
Answer
This warning message originates from Excel® and may come up, if the command "RunContinuous" is used. Choose one of the following solutions to avoid this message:
Use "RunSingleStep" instead of "RunContinuous" in the following way:
for i = 0 to simulation.Period * simulation.Resolution simulation.RunSingleStep DoEvents
next i
Switch off all Excel® warnings using the VBA command:
Application.DisplayAlerts = False
Use a different programming environment.