how to make write protect for Excel

[Balavbs_83]

Hi all

I need a clarification from you all

I am exporting my data's to Excel sheet and saving it in the hard disk.

I need to protect the sheet with password for opening the sheet

Kindly can anyone help me in this

Thanks

Regards

Bala

[Ray.R]

Have a look at the image below to password protect your workbook:

Make sure that you close all the references to Excel. Each refnum wire needs to end either in an indicator if it is going to be a sub VI, or an Automation close if the VI is not a subVI.

Message Edited by JoeLabView on 06-24-2008 12:33 PM

[Ray.R]

Here is the example if you want to protect individual sheets:

I didn't do these examples..  So ignore the string of question marks, it should have been a boolean indicator..

Saving will be similar.  Just look for the SAVE property within the property node selection.

RayR