Hi,
I do a process control simulation, where a process simulation is performed via an Excel macro while the controller and vizualization are realized in LabVIEW:
The control in LV generates the actuating signal, writes it to the excel sheet (via set_cell_value.vi), starts the excel simulation macro and then reads the process variables. (via get_cell_value.vi). This is repeated for every simulation step. It works fine, yet with increasing simulation duration the time from calling the macro until completion (the calculation time) increases: Starting with 1700 ms per cycle it comes to 5500 ms after 500 simulatin cycles.
Running the macro alone in a loop in excel keeps the calculation time constant at about 2000ms,however. What "piles up" when calling a macro in each simulation step ?
Are there ActiveX parameters that must be set somehow ?
Attached please find jpgs of the ActiveX macro call and the time measuring in LabVIEW and the macro in excel (only the root).
regards
Uli Hoffmann
