can not open excel file 2009

[SeanJ]

Hi,

I recently upgraded my machine to LabVIEW 2009.  I already had created a sequence file that ran on LabVIEW 8.5.

However when I run it on LabVIEW 2009, it fails to open an excel template that I use for storing results.  In fact I cannot open any excel spreadsheet using the standard vi.

What appears to be happening is that once the VI progresses to the subvi Excel_Open_Workbook.vi the error occurs.  The error actually occurs after the invoke node, see attached image, and appears as follows

Error -2147352573 occurred at Member not found.
 in NI_ReportGenerationToolkit.lvlib:Excel_Open_Workbook.vi->NI_Excel.lvclass:new report subVI.vi->NI_report.lvclass:New Report.vi->demo.vi

This error code is undefined. No one has provided a description for this code, or you might have wired a number that is not an error code to the error code input.

Does anyone know how I can correct this error? Is there a way of maybe reinstalling the excel generation VI's? Is it a known issue with labVIEW 2009?

[SeanJ]

I neglected to mention, I ran MSI blast and repaired the LabVIEW 2009 Report Generation Toolkit and the License. 

This did not fix the issue!  

[david.bolt · Accepted solution]

Hi SeanJ

What version of the Report Generation Toolkit are you using?  The latest version (1.1.4) requires the use of Microsoft Office 2007/2003/XP as per the Readme.  This appears to be one of the limitations associated with the previous version of Excel. You have an incompatible Report Gen Toolkit with the Mircosoft office version you are using. Make sure the version you have is compatible with the Excel.

After installing the LV development system on your computer, the issue could also be that some ActiveX methods have been disconnected. If you re-point the Invoke Nodes to the appropriate ActiveX methods this should solve your problem.