Help Creating Password protected Excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

!TG - 13 Jun 2008 22:46 GMT

I can't seem to figure out how it's done. I know it has to be something
fairly simple.
I know how to open an excel file, but I'd like to open it, insert values and
save it with a different name and password protect.

Reply to this Message

Bob Barrows [MVP] - 14 Jun 2008 14:31 GMT

> I can't seem to figure out how it's done. I know it has to be
> something fairly simple.
> I know how to open an excel file, but I'd like to open it, insert
> values and save it with a different name and password protect.

Using ASP?
Password protecting a spreadsheet is not possible without getting Excel
itself involved. In a non-server development environment, this would be done
by Automating Excel, i.e., creating an object of type Excel.Application and
using the methods built into the Application object to apply password
protection. In a server-based environment like ASP, this is a risky route to
take and MS strongly advises against automating Office applications in
server-based code. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;257757

Signature

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Reply to this Message

Webmaster Forum / ASP / Database Access / June 2008

Help Creating Password protected Excel file