LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel 2002

Has anyone made VIs that read Excel 2002 spreadsheets (on a development machine with Excel 2002) but, when built in to exe and run on a machine with Excel 2000, still work?
0 Kudos
Message 1 of 3
(2,846 Views)
Did you already try this and succeeded, or are you asking should it work?
I assume you want to read from Excel using ActiveX technology, and not through some dll. (Report Generation VIs are also based on activex)
You may be run into problems when trying to run on a machine with Office 2000 an executable that was built on a machine with Office 2002.

First, it is important to understand that Microsoft changed its underlying Active X Object Model between the two different releases of Office 2000 and Office 2002. Non-LabVIEW applications will experience the same problem.

When installing LabVIEW Report Generation Toolkit, the installer automatically detects the version of Microsoft Office installed on your system and installs the appropriate files.
Similarly
with just pure activeX calls to Excel. The Excel objects� references, properties and methods used in the VI, will be for that specific version of Excel and activeX objects. Some of those objects may be missing or have different properties in Excel 2000 and 2002. This will cause the executable not to run properly.

Depending on the size and complexity of the LabVIEW VI, you might be able to make simple edits to update the VI, however it is suggested that you create the VI again from another PC that has Microsoft Office 2000 installed.

Zvezdana S.
National Instruments
0 Kudos
Message 2 of 3
(2,846 Views)
This is something I actually tried to do, but it did not work. It appears that if you write the ActiveX reading VI (for Excel) on a machine with Office 2000 machine, it will work on a machine with Office 2000 or 2002 but, if you write it on a machine with Office 2002, it will NOT work on a machine with Office 2000. Furthermore, if the VI was orignally written on a machine with Office 2000 and you go to build it into an EXE on a machine with Office 2002 you get an error of 1003, because the VI is unexecutable (even though the arrow is not broken until a mass recompile of the VI) due to the change in Active X controls. Quite annoying!
0 Kudos
Message 3 of 3
(2,846 Views)