"Error -2147352573 occured at Member not found" when trying to open an excel template

[PhilipHambley]

I'm trying to open an excel document as a template using the report generation tools but coming up with this error.  I've traced the error to NI_ReportGenerationToolkit.lvlib:Excel_Open_Workbook.vi but have to idea why it's happening.  The document seems to be fine as I can open and edit it in Excel.  Has anyone else seen this?  I'm using Labview 8.6 and Excel 2000.  I've attached an image of the error and it's source.  Thanks.

[RavensFan]

Your embedded image does not show up because it points to a location on your hard drive.  You must attach the image to your message first.  Then once you posted the message, you can edit the message and embed the image based on its path to the NI webserver.

Second, please don't post Word documents with images embedded in them.  Other people refuse to open Microsoft Word documents.  But the problem for me is that it creates a much larger file to download than necessary.  Your attachment is over 1/2 MB when the image is probably only about 50 KB.

[PhilipHambley]

Thanks, I've added an image of the error, hopefully not just a link to something on my hard drive.

Message Edited by zeppelin_79 on 10-13-2008 09:27 PM

[PhilipHambley]

Sorry, my final attempt to post a picture:

 

[muks]

Have you gone through this thread?

[Philip_Courtois]

Did you resolve this issue? If so, what was the solution? To me it seems like there's an incompatibility issue with the "Open" method and Excel 2000... I get the error with Excel 2000, but not with 2002, 2003 and 2007.

[George_P_Burdell]

Philip-

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.

[Philip_Courtois]

Hi Mike,

Thanks for pointing out the compatibility issue. I got the error with version 1.1.3 and therefore upgraded to 1.1.4 - after taking a glance at the readme document. I guess that I was mistaking the supported OS version ("Windows Vista/XP/2000") with the supported version of MS Office ("2007/2003/XP").

I originally received the error when running an executable on a Office 2000 machine. The executable was built on a Office 2003 machine since I have previously been able to build on Office 2003 and run on 2000. I'm not sure what was different with this executable. Anyway, after installing the LV development system on the Office 2000 machine, the issue turned out to be that some ActiveX methods had been disconnected. All I had to do was re-point the Invoke Nodes to the appropriate ActiveX methods.

Please note that my application in this case is very simple and therefore only exposes a small part of the Office 2000 ActiveX API. I'm sure that I would run into a non-compatibility wall if I were to implement more Office 2000 functions with RGT 1.1.4.

Message Edited by Philip Courtois on 06-18-2009 01:26 PM

[RossGE]

I am running a computer that has MS 2003 and am getting this same error trying to accomplish the same goal any ideas?

[muks]

What is your labVIEW version?