Excel Get ActiveX References VI

LabVIEW 2018 Report Generation Toolkit for Microsoft Office Help

Edition Date: June 2018

Part Number: 370274M-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Excel Advanced VIs

Requires: Report Generation Toolkit

Returns ActiveX references to Microsoft Excel.

You can wire the references this VI returns to a Property Node or Invoke Node to configure the properties and methods available for the reference. You can use the properties and methods to control the appearance, data, and printing of a report.

Note  Do not close ActiveX references opened with the Excel Get ActiveX References VI. References must remain open until the report is closed. Otherwise the error 3001 will occur.

report in is a reference to the report whose appearance, data, and printing you want to control. Use the Create Report VI to generate this LabVIEW class object.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
Excel._Application is a reference to the application Microsoft Excel.
report out is a reference to the report whose appearance, data, and printing you want to control. You can wire this output to other Report Generation VIs.
Excel._Workbook is a reference to the active workbook.
Excel._Worksheet is a reference to the active worksheet.
Excel.Sheets is a reference to all the worksheets in the active workbook.
error out contains error information. This output provides standard error out functionality.
Excel.Shapes is a reference to graphics in the active worksheet.

WAS THIS ARTICLE HELPFUL?

Not Helpful