LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I protect/unprotect Excel Worksheets with Activex

Hi,
 
I am reading and writing some data to Excel.  I have the Report Generation Took Kit.  I am trying to unprotect a sheet, do my stuff, then protect it.  I modified the Excel Get Worksheet vi. to include the protect invoke node, but the worksheet is never goes into protection.  I have attached the protect vi that I am trying to use. 
 
Any way to do this works for me, and it doesn't have to be as attached. Thanks
0 Kudos
Message 1 of 8
(5,737 Views)
Well don't I feel silly. For this to work the Get Worksheet Function had to be used first to actually get the sheet. See attached.  This now works fine.  Download both files to see.

Message Edited by hyatt on 12-20-2005 02:09 PM

Message Edited by hyatt on 12-20-2005 02:10 PM

Download All
0 Kudos
Message 2 of 8
(5,730 Views)

I have the same question, but I am running lab View 7.1.  Can the person who responded please create a 7.1 version of the VI's? 

Thanks!!

0 Kudos
Message 3 of 8
(5,548 Views)
The VIs posted will open in 7.1.  You need the Microsoft Office Toolkit for the VIs to run, though.
0 Kudos
Message 4 of 8
(5,538 Views)
It looks like Protect.vi is for LabVIEW 7.1 in the first post.  I didn't see that any changes were made to it in the second post, but I converted that one just in case.  Here are both, saved for version 7.1. 
Jennifer R.
National Instruments
Applications Engineer
Download All
0 Kudos
Message 5 of 8
(5,511 Views)
Thanks!
0 Kudos
Message 6 of 8
(5,498 Views)

I am trying to create an excel report after data acquisition in LabVIEW 8.6.1.

So that the operators cannot edit the template, I password-protected it.

Now

the I am searching online for forums on how to do so. However examples does not fit to the current version that we have since vis such as 'get report to modify' (I am not sure if its the right name) is already a feature removed

from this version.

I believe the basic issue is how to transform the 'report out' into an application 'refnum' so as the excel would be unlocked.

 

Please shed some ideas

0 Kudos
Message 7 of 8
(5,221 Views)

Peejay,

 

Continue here

0 Kudos
Message 8 of 8
(5,206 Views)