Overview
This VI displays the functionality of a state machine by controlling the execution of a code.
Description
Inserting a hyperlink into an Excel worksheet is not a feature available in the Report Generation Toolkit. This example is one way to insert a hyperlink into a worksheet. The example uses an Excel macro (saved as a .bas file) to add the hyperlink to the worksheet. The VI Opens an Excel Workbook (.xls) and load the AddHyperlink macro. The example then runs the macro, removes the macro from the workbook, and saves the document.
Requirements
- LabVIEW Base Development System 2012 (or compatible)
- Report Generation Toolkit
Steps to Implement or Execute Code
- Download the zip file "Add Hyperlink to Excel 2012 NIverified.zip"
- Open the VI "Add Hyperlink to Excel 2012 NIverified.vi"
- Select an Excel file to modify
- Choose a Cell to modify, URL to paste, and Link text
- Run the VI
Additional Information or References
VI Block Diagram
**This document has been updated to meet the current required format for the NI Code Exchange.**