11-08-2004 12:49 PM
11-09-2004
12:59 PM
- last edited on
08-24-2026
09:08 AM
by
Content Cleaner
Hello �
Is the error happening when the cell value is #NULL or #NA only?
Sometimes these errors occur because of an ActiveX object mismatch. The version of the ActiveX object might have changed or been updated since the VI was created. The VI tries to use an earlier, incompatible version of the ActiveX object.
To solve the problem, you need to link automation refnum terminal to the correct ActiveX object. To do so, right-click an automation refnum terminal and choose Select ActiveX Class»Browse from the shortcut menu. From the Type Library pull-down menu, select the latest version of the library you want to use, such as Microsoft Excel Object Library. In the Objects list, select an ActiveX object, and click the OK button. Link ea
ch automation refnum terminal in the VI and its subVIs until the run arrow is not broken. Also, you might have to replace some or all of the Invoke Nodes and Property Nodes for the ActiveX objects.
Hope this helps.
S Vences
Applications Engineer
National Instruments
01-07-2015 03:26 AM
You can try using "Excel Find and Replace.vi" to replace all "=NA()" data with "NaN". I had tested it and my Labview was able to retrieve the excel table without issue