Excel get worksheet.vi , Error -41110

[RJ123]

I created a program on my PC and it works as it was expected.  The program was deployed to a user PC and I am getting the error -41110 within Excel get worksheet.vi.  Very simply, the program calls to sheet1 and sheet 2 using the index 0 and 1 back and forth writing data.  I am not sure what the problem is.  My PC has Excel 2007 and many of the users will have Excel 2003.  Any thought on the issue or how to resolve it.  I will not have access to the user PCs, so the fix must be done on the program side. 

[Hillman]

Hi RJ123,

Thanks for your post and I hope your well today.

The error normally related to this,

This error typically happens when trying to write data to a worksheet on the workbook that is not the first one. The Report Generation Toolkit only supports writing data to the first worksheet on a given workbook. In order to fix this, make sure that you are only trying to write data to the first worksheet.

Also, what version of report generation toolkit are you using? When you deploy you need to have the correct version of office and also use the correct version of the report generation vi's. In your exe build you have to add the dynamic llb (_exclsub), but I beleive there are different versions for each version of office.

Please let me know a bit more about your setup and if indeed your error is being caused by the typical case - but if it works on your develop machine, then I would suspect its an issue with deployment including Report Generation and Office. 

Kind Regards,
James.

[RJ123]

Thanks for the feedback. 

I do not see anywhere I can choose what version of Excel I will deploy to or that uniquely idenitfies the excel version the vis associate to.  Also, I am successful at writing to any number of worksheets in a workbook as long as it is called to one at a time, on my PC.  The dynamic vis are loaded and as noted it works on my PC.  The report generation toolkit version is 1.1.2.

[Hillman]

Hi RJ123,

Thanks for the update and I hope your well.

If you go to this directory,

C:\Program Files\National Instruments\LabVIEW 8.5\vi.lib\addons\_office

You will find a text file titled 'office2007'.

It states,

"

These 4 libraries contain Office 2007 compatible VIs. _exclsub.llb\_Excel Dynamic VIs.vi and _wordsub.llb\_Word Dynamic VIs.vi must be added as support files when building an application or a dynamic link library with the application builder.

The Office 2000, XP, and 2003 compatible version of these libraries can be found on the package CD.

"

I beleive you need to get the correct libraries for your version of office OR install the same version of office which is the development machine onto the deployment machines.

Note: When making an exe these libraries have to be included.

I hope this helps,