Cannot Access Methods or Properties for Microsoft Office ActiveX References

Updated Oct 2, 2018

Reported In

Software

  • LabVIEW
  • LabVIEW Report Generation Toolkit

Other

  • Microsoft Office
  • Microsoft Word
  • Microsoft Excel

Issue Details

I am using the LabVIEW Report Generation Toolkit to generate Microsoft Word or Microsoft Excel reports. I have custom formatting that I need to apply using Property and Invoke Nodes.

  • When I try to select a class for Property or Invoke Nodes, I do not see the Microsoft Excel or Microsoft Word type libraries.
  • When I load existing code, I cannot edit the existing nodes. Instead, my ActiveX Property and Invoke Nodes show No Properties or No Methods.
  • When I drop a property node or invoke node on the block diagram, there are no classes or methods to select. I also cannot modify property nodes within LabVIEW examples.
How can I access these properties and methods? 

Solution

This behavior can happen if you use LabVIEW 32-bit and Microsoft Office 64-bit. For example, Excel 2016 64-bit will not work with LabVIEW 2018 32-bit. To solve this issue, use LabVIEW 32-bit with Microsoft Office 32-bit , or, LabVIEW 64-bit with Microsoft Office 64-bit.

Additional Information

Refer to About Office: What version of Office am I using? for steps to check the bitness of your Microsoft Office installation.

While it seems possible to use LabVIEW 64-bit with Microsoft Office 32-bit, it is recommended to have matched bitness between LabVIEW and Microsoft Office.

WAS THIS ARTICLE HELPFUL?

Not Helpful