active x error

[Ken_Naylor]

The error is caused by an empty string going to a worksheet.Range.  The empty string is the output of the SELECTEDcellsTDMS.vi  which is empty if the input Selected Cells 3 is not empty. 

Race condition

In SELECTEDcellsTDMS.vi you use the value of Selected Cells 3 as a input to the case structure which could (and probably would) occur before the Selected cells 3 - Reinit to Default

Force the order of execution by wiring the error out of   Selected cells 3 - Reinit to Default to the error in of Selected Cells 3 - value.  that way it will always be empty, the cases structure will operate and 'Selected cells' will not be balnk 

[alan4]

sorry but i don't understand very well yor explanation, so what must i do, reint to default selected cells 3??

sorry ;(

thanks!

[Ken_Naylor]

easier if I amend the vi and send it you back.  What version of LabVIEW are you running so that I can send it to you as the right version

Ken

[alan4]

2010 sp1

thanks for all!!!

[Ken_Naylor · Accepted solution]

SELECTEDcellsTDMS.vi saved for version 2010 attached

[alan4]

after changing this vi appears same error in openworksheettdms...

i try to change it but i don't know...thanks

[Ken_Naylor]

It runs fine on my PC (multiple times giving the same result) do you change the Excel sheet between runs?

If you open the Block diagram of openworksheettdms and turn on execution highlighting (light bulb icon) and then run the top level vi READ_XCLPRUEBA1.vi you can see which Excel Property node or invoke node is causing the error.  Check the inputs to this node to check that they are valid and are they what you expect?

This should go a long way to helping you solve the problem.

Ken

[alan4]

the error apears when we change de range of cells, after this appear the error, all this in worksheettdms

[alan4]

thanks i solve it was a bad conection sorry!