ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

Home Community Example Programs Example Code Document

Example Code

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ASK A QUESTION

Unprotect Excel Sheet with ActiveX Using LabVIEW

by: Active Participant
‎04-02-2014 10:54 AM
Last Edited by: Member Example_Scrubber_Haixiang ‎08-02-2017 01:36 AM

Products and Environment

This section reflects the products and operating system used to create the example.

To download NI software, including the products shown below, visit ni.com/downloads.

    Software

  • LabVIEW

Code and Documents

Attachment

Download All

 

Overview

This example uses ActiveX to open and unprotect a protected Excel Worksheet.

 

Description

This example opens a reference to an Excel workbook, opens the workbook, and unprotects a sheet in the Excel workbook.

 

Requirements

  • LabVIEW 2012  (or compatible)

 

Steps to Implement or Execute Code

  1. Change file path to Excel file you want to open.
  2. Enter correct password for protected sheet.
  3. Click 'Run' or run arrow.

 

Additional Information or References

VI Snippet of Block Diagram

sni.pngsni.png

 

 **This document has been updated to meet the current required format for the NI Code Exchange. **

------------------------------------------------------------------------------------------

Jon F.
Technical Support Engineer
National Instruments

Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.

0 Kudos