Error -41110 After a Few Runs Writing Data to Excel or Word

Updated May 21, 2019

Reported In

Software

  • LabVIEW
  • LabVIEW Report Generation Toolkit

Operating System

  • Windows

Issue Details

  • When I use LabVIEW Report Generation Toolkit to write data to an excel file, I get the following error code after running my VI. Why is this happening?
  • I'm trying to write to bookmarks in Microsoft Word that I know exist. The code executes all of the "Append Report Text" calls, but I'm getting the following error and the report is only documenting 4 of the bookmarks. What am I doing wrong?
Error -41110 occurred at Append Report Text.vi

Possible reason(s):

Report Generation Toolkit: You specified invalid Word bookmarks or Excel named ranges.

This error is shown in the following dialog box.

Solution

The error could be caused by two different things, depending on which software you are using. Some helpful troubleshooting steps can be found below.

Error in Microsoft Word

Confirm the bookmarks being specified actually exist. Confirm there are no typos or misspellings.

Error in Microsoft Excel

To create a new excel worksheet, use the add_worksheet.vi from the Report Generation Toolkit before the get_worksheet.vi. Include the add_worksheet.vi for every new worksheet needed.
  • If translating to a different machine, ensure that the specified Excel spreadsheet has the correct file path

Additional Information

  • The get_worksheet.vi does not create new Excel worksheets if they do not exist. This is why the add_worksheet.vi is necessary to include. 
  • The get_worksheet.vi accepts worksheet index or name as inputs, but not both at the same time. 

WAS THIS ARTICLE HELPFUL?

Not Helpful