How to password protect an excel sheet with labview?

[Rajesh_Nair]

Hi all

I want to protect my excel sheet by putting password. How can we do that in LabVIEW? In my application we are writing some data into an excel sheet. It should not be edited. Is there any other method to make this happen other than putting password?

I am a beginner. Please help me!

Regards

Rajesh

[MoReese]

You should be able to by using your tools>options>security settings to set the password.  To do this with LV would require you to use a macro or an activeX control.  I have found the macros are fairly easy to use and LV has some advanced file functions specifically for excel.  Look into the Excel Macros in the Report Generation Toolkit.  Specifically, Run Macro.vi.

[Wayne.C]

Rajesh,

I've attached a VI snippet that demonstates ActiveX method to set protections and password.

[Rajesh_Nair]

Hi Mo Reese

Thank you for your valuable reply! I don't know much about macros. Anyway i will try to learn.

Hi Wayne

Thank you for the reply and VI snippet. I think your reply will help me a lot.

Thank you again for all

regards

Rajesh

[michele.santucci]

I tried with your solution with this:

No errors.. but no password is set ...

[Wayne.C]

Just a single worksheet in the workbook?