LabVIEW compatability with Excel

[Rsn1]

I currently have a LabVIEW 2014 program that prints results to an Excel 2007 spreadsheet. I downloaded the program to to disc & uploaded it to an additional computer operating on LabVIEW 2013 but it will not print to Excel 2013 spreadsheet on the new computer. Instead I receive Error 97. A subVI within the program is seeing the excel spreadsheet as a null or possibly deleted Refnum. How can I fix this so as to get both computers available in order to run the test?

[billko]

I'm assuming that you are talking about a LabVIEW executable?  Does copying any executable to another computer and then trying to run it work?  Most probably not.  You need to at least install the correct LV runtime, and probably more.  The best bet would be to build an installer for that executable and let LabVIEW worry about what to include.  then install it on the other PC.

[Rsn1]

Bill

You are correct to assume that the program is an executable in so far as it is collecting the V & I data off a generator during various load scenarios, running an evaluation of that data and providing a report on an Excel spreadsheet that includes waveform images.  Unfortunately I do not know how to  build an installer for that executable and let LabVIEW worry about what to include.  Is there a procedure I need to follow when transferring the program off the main computer, as I intend to copy the program onto laptops so that I can test units in the field as well as the alternate desktop we have in the lab?

Thanks for any help you can provide.

[Rsn1]

The Error 97 reads as follows: "Unknown System Error in NI Report Generator Tool Kit.LVLib; Excel_Get_Range.vi>NI_Excel.LV Class:Excel Set Cell Color and Border.vi>SVI-Titleblock.vi>DC Power Supply Main .vi"

Within the Excel_Get_Range.vi the excel input is not being recognized.

[Bob_Schor]

If the program was built with LabVIEW 2014, then it needs to run with the LabVIEW 2014 Run Time Engine.  If you do a Web Search for LabVIEW Run-Time Engine, you'll find several links.  Download the one appropriate to the 32/64 bittedness of your LabVIEW system (almost certainly you are using LabVIEW 2014 32-bit), and also choose whether you are using 2014 or 2014 SP1 (this latter distinction might not be necessary).  Note that when you go to NI's site, you see (gasp!) the NI Package Manager.  Don't panic, but do note you need to click "Runtime" under "Included Editions".

Bob Schor

[billko]

---

@Bob_Schor wrote:

If the program was built with LabVIEW 2014, then it needs to run with the LabVIEW 2014 Run Time Engine.  If you do a Web Search for LabVIEW Run-Time Engine, you'll find several links.  Download the one appropriate to the 32/64 bittedness of your LabVIEW system (almost certainly you are using LabVIEW 2014 32-bit), and also choose whether you are using 2014 or 2014 SP1 (this latter distinction might not be necessary).  Note that when you go to NI's site, you see (gasp!) the NI Package Manager.  Don't panic, but do note you need to click "Runtime" under "Included Editions".

Bob Schor

---

Bob:

Can't they just build it in LV 2014, create an installer and install the executable to the other PC?  I think the installer would include the LabVIEW runtime.

[Bob_Schor]

---

@billko wrote:

---

Can't they just build it in LV 2014, create an installer and install the executable to the other PC?  I think the installer would include the LabVIEW runtime.

---

Don't know.  I've not done many Installers, but have done "brute force" (i.e. Copy These Files to Those Folders) of LabVIEW "Applications" (.exe builds) + download/copy RTE if necessary.  I also don't know how much experience the OP has with building executables and installers, nor what software is installed on the Host machine ...

BS

[Rsn1]

Bill

After consulting with colleagues, my answer was not 100% correct.  This is not an .exe. file.  I am a LabVIEW user & amateur developer.  I am working in a large vi. I need to use the other computer in the lab that has LV13.  I simply copied the LV14 into this computer & ran into problems.  The program runs, but will not print out the report to Excel13 which is on the alternate computer.

Does this change the possible solution to my issue, as I investigate the use of an installer??? 

[BertMcMahan]

I have had bitness issues with Excel. I don't remember which version it started with, but at some point Office 64-bit wouldn't work with 32-bit applications. This could have something to do with your issue.

You could try installing Office 32 bit or LabVIEW 64 bit versions to see if that works.

[Bob_Schor]

---

@Rsn1 wrote:

The Error 97 reads as follows: "Unknown System Error in NI Report Generator Tool Kit.LVLib; Excel_Get_Range.vi>NI_Excel.LV Class:Excel Set Cell Color and Border.vi>SVI-Titleblock.vi>DC Power Supply Main .vi"

Within the Excel_Get_Range.vi the excel input is not being recognized.

---

This seems to me to be a program that is doing something other than just a simple Excel "Write Table".  Sorry, we need to see the actual LabVIEW code (one or more .VI files that we can actually edit and run as necessary) along with a sample of the data you are trying to write.

Also, if you have a LabVIEW VI that was saved in LabVIEW 2014, you should not be able to open it (much less run it) on a computer with LabVIEW 2013, contrary to what you stated in a recent previous message.

Bob Schor