How to use active X controls to read/write protect an excel or word document created by created by Save Report to File VI

[OD]

Hi all,

I'm trying to creat a word and excel documents using Save Report to File VI. When wiring a password to this last VI, the document created are only protected against writing but not reading. How can I use active X controls to password protect these documents against reading?

Thanks a bunch!

O

[Norbert_B]

There is no predefined functionality available in LabVIEW. So you have to implement this on your own.

It seems to me that you own the Office Report Generation Toolkit. You can use the Excel Get ActiveX References.vi from the Excel Specific >> Advanced palette to get access to the "generic" ActiveX Excel references. Starting from this point, you can use property and invoke nodes to get to the setting you are going to modify.

Please refer to this link for information on Excel password protection. I have not searched for the object giving you access to those settings though....

hope this helps,

Norbert