LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

ActiveX, Macro, calculation time

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 

 

 

 

0 Kudos
Message 1 of 2
(2,481 Views)

i am not sure about what the problem could be. It could be that LV call Excel via ActiveX. Not sure though. What is the reason for using an Excel Macro insted of foing it in pure G.

 

 




Joe.
"NOTHING IS EVER EASY"
0 Kudos
Message 2 of 2
(2,456 Views)