My Report Generation Toolkit Application Does not Work with MS Office

Updated Dec 23, 2023

Reported In

Software

  • LabVIEW 2015 Report Generation Toolkit

Operating System

  • Windows

Issue Details

If you create applications with NI Application Builder that contain VIs from the LabVIEW Report Generation Toolkit for Microsoft Office, you cannot use these applications with some Microsoft Office versions.

Solution

The LabVIEW Report Generation Toolkit for Microsoft Office uses several Microsoft Office functions that are called with the LabVIEW Property Node or Invoke Node. Due to changes in the transfer parameters of some Microsoft Office functions, the following (Sub-)VIs were modified to enable them to automatically adapt to the respective Microsoft Office version when loading:
 
  • Excel_Print.vi
  • Excel Set Cell Color and Border.vi
  • Word_Add_Document.vi
  • Word_Open_Document.vi
  • Excel_Save_Workbook.vi
The modifications in these VIs do not work, however, if you create an executable application with the NI Application Builder, because the Report Generation Toolkit VIs are dedicated to a specified Microsoft Office version. So, when you are creating applications with NI Application Builder, make sure that the Microsoft Office version on the computer on which you create the application corresponds with the Microsoft Office version on which you intend to use the application. Please note that there may be changes within one and the same Microsoft Office version, such as a change within Microsoft Office 2016, which required the modification of Excel_Save_Workbook.vi.