LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview and Excel

Using Laview V6.1 on Win2000 with Office 2000 Excel. I have attached the following VI and excel sheet. I get a error 97 in the cell value.vi I believe I am setting up the refnums correctly. any thoughts?
Download All
0 Kudos
Message 1 of 4
(2,887 Views)
Since you didn't attach the subVI Set Cell Value, it's impossible to fix but one thing I think you should do is keep the same references and pass them and use dataflow with the error in/error out connections. I'm refering to that little sequence you have at the bottom. Why not just pass the workbooks ref that you already have and then pass the sheets ref to the subVI. Also, don't close the sheets ref before you pass it to the subVI. You need to keep it open for the subVI to work.
0 Kudos
Message 2 of 4
(2,887 Views)
Sorry for the oversite, here is the vi.
0 Kudos
Message 3 of 4
(2,887 Views)
The refs were not set correctly. Here's a modified version that I think does what you want.
0 Kudos
Message 4 of 4
(2,887 Views)