Error -2146827284 When Using New Report VI From LabVIEW Report Generation Toolkit

Updated Jul 29, 2020

Reported In

Software

  • LabVIEW Report Generation Toolkit
  • LabVIEW

Issue Details

I am developing a LabVIEW VI using the Report Generation Toolkit for Microsoft Office. I am creating an Excel document using the New Report.vi and writing values to that report using the Excel Easy Text.vi. An example snippet of my code is shown in Figure 1 below:
 
Figure 1: Snippet to Reproduce 2146827284 Error


When I run my program my report is not written to and my error handler reports Error 2146827284 ("Error 2146827284 occurred at an unidentified location."). Figure 2 below displays the error when using a Simple Error Handler.vi. What causes this error to occur and how do I prevent it from happening?

Figure 2: Error Reported by Report Generation Toolkit VIs

Solution

This error is being thrown by an specific invoke method within Excel Easy Text.vi. The following fixes will prevent this error from being thrown. 
 
  1. Change the minimized enum constant connected to the New Report.vi to maximized, no change, or normal (One example can be seen below in Figure 3.)
  2. Make sure you have the Microsoft Excel program fully opened before running your program.
 
Figure 3: Solution Snippet ("minimized" enum changed to "maximized")


If the above changes do not prevent this error from being thrown, check the following criteria:
 

  • The error occurs after a specific length of execution time
  • You are using Microsoft Excel 2003 or earlier

If your program meets this criteria then this error is likely being thrown due to the pre-2007 Microsoft Excel spreadsheet size limit being reached.