LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Active X to Excel error

I want to read an excel file and export data from specifcs cells in the sheet.

Unfortunately at the beginning of the VI the error -2147221163 appears on the automation open.

Can someone help me?

Thanks

 

0 Kudos
Message 1 of 2
(140 Views)

I (strongly) recommend that you get rid of the Sequence structure, remove the Error Out 2 and connect the "loose" Error Line to the Application Property Node.  If you want/need a 3-second delay between the code inside the Sequence Structure and the ActiveX code, drop a Stall VIM (found on the Timing Sheet) on the now-continuous Error Line.  Who knows, maybe an Error in that first bit of code was "gumming up the works.

 

I'd also request that you attach an example of the Excel Workbook you are trying to open (be sure there's data present in cells C3 and G5.

 

There clearly seems to be a bug somewhere.  Maybe it's in the code you submitted, maybe it's in the Workbook, maybe you have a "bug in Excel" ... 

 

Bob Schor

0 Kudos
Message 2 of 2
(122 Views)