Where Can I Find Microsoft ActiveX Methods and Properties?

Updated Jul 11, 2023

Reported In

Software

  • LabVIEW
  • LabVIEW Report Generation Toolkit

Issue Details

I am trying to develop a LabVIEW application that uses Microsoft Office ActiveX Automation. I am particularly interested in taking advantage of the exposed methods and properties of Microsoft Excel. Where can I find more documentation on Microsoft ActiveX methods and properties?

Solution

A wealth of information is available at Microsoft's website at the MSDN Online Library Office Developer Center.

Here is an example of MSDN Online Library directory tree to find Excel's object model description:
Excel (2013 and higher):
Office Developement»Office clients»Excel»Excel VBA reference»Object model


This should provide an alphabetical listing of objects available to you.  See the details of each object for documentation on its properties and methods. 

Additional Information

Microsoft Word and Microsoft Excel are powerful standard software packages for creating reports. Due to their popularity, some LabVIEW users programmed LabVIEW ActiveX applications to dynamically control these document packages for generating reports from LabVIEW. 

The complexity of the ActiveX interface of those packages, however, makes the development of custom applications difficult. With the LabVIEW Report Generation Toolkit for Microsoft Office, you no longer need to learn the complex object models of Microsoft Word and Excel to generate a report. The Report Generation Toolkit is a library of flexible, easy-to-use VIs for programmatically creating and editing Microsoft Word and Excel reports from LabVIEW. The Report Generation Toolkit is included with LabVIEW Professional 2014 and later.