LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

problems with excel toolkit (GOOP)

I use LabVIEW 6.1 on Windows 2000 and I have correctly installed "GOOP Wizard" as in demand. When I use "excel close.vi" It give me error 1. The error originates from the VI "excel objectrepository.vi".
0 Kudos
Message 1 of 3
(2,859 Views)
I have the same problem with LabVIEW 6.0.2. I just edited the excel close.vi and changed the code to ignore error # 1. NOT a good solution, but it got me farther.Now sometimes I get an error, "Excel has caused an error in LVSF.TMP. This seems to happen when my code opens an Excel worksheet and closes it with no changes. LabVIEW will now close" I'm submitting this question today. Did you ever solve this?
0 Kudos
Message 2 of 3
(2,859 Views)
As it turns out, my dirty solution of ignoring the error#1 did not solve all problems when shutting down Windows, and other situations. I gave up completely on using Excel API stuff. Since I was using no calculations, I re-coded all VIs to use reading tab-delimited text files into a multi-column listbox and to use several VIs I coded last year to get/change values (and attributes) in those "cells" instead. Works like a charm. No more "Excel has caused an error" messages. No more concerns about whether using Excel API requires licensing Excel, etc. Simple, no more Excel! This worked great also, BTW, for no longer using Microsoft's flexgrid controls and its associated API/COM crap in my front panel(s). Using multi-column listboxes, I found, is much prettier
and just as fast for GUI displays. I feel much better now, no API's except for ones used by LabVIEW and TestStand. No more DCOM/Registy headaches. Only have to use NI's products greatly simplifies my life!
0 Kudos
Message 3 of 3
(2,859 Views)