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

How can I hide worksheets in excel?

by: Member
‎11-13-2010 03:37 AM
Last Edited by: Member Aashish_M ‎01-27-2017 03:58 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 shows how to get an ActiveX reference of a Microsoft Excel sheet and use it to change its "Visible" property

 

Description

This example opens an Excel report, adds a worksheet, gets the worksheet that was just added, converts the worksheet into an ActiveX reference and uses that reference to change the "Visible" property of the page to set xlSheetVisible, xlSheetHidden and xlSheetVeryHidden.


Requirements

LabVIEW 2012 (or compatible)

 

Steps to Implement or Execute Code
1. Verify you have Excel installed.
2. Run the VI.


Additional Information or References

Snippet.png

Aashish M
CEO
TransferFi
www.transferfi.com

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

0 Kudos