Need example: Add password to Excel file.

Greetings,

I have an existing Excel file. I need to programatically password protect
the file so that it can't be read unless the password is entered.

Any code examples?

Thanks!

[c# 2005]


--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

re: Need example: Add password to Excel file.

vbMark,

All you have to do is call the SaveAs method on the workbook. There is
a Password parameter that you set to the password you want to be used for
opening the workbook.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

"vbMark" <no@email.com> wrote in message
news:Xns972069267ED1Dvbmark@199.45.49.11...[color=blue]
> Greetings,
>
> I have an existing Excel file. I need to programatically password protect
> the file so that it can't be read unless the password is entered.
>
> Any code examples?
>
> Thanks!
>
> [c# 2005]
>
>
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Best free software
> http://www.vbmark.com
> Freeware-dedicated search engine
> http://www.eurekster.com/parties/Freeware1.htm
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[/color]

re: Need example: Add password to Excel file.

"Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard.caspershouse.com> wrote
in news:urjypU19FHA.360@TK2MSFTNGP09.phx.gbl:
[color=blue]
> vbMark,
>
> All you have to do is call the SaveAs method on the workbook.
> There is
> a Password parameter that you set to the password you want to be used
> for opening the workbook.
>
> Hope this helps.
>
>[/color]

Worked great. Thanks!

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-