[thelist] Password-Protect Downloadable Excel Files

[Ken Schaefer]

Is this actually an Excel spreadsheet or a CSV (Comma Separated Value)
document? 

The former is a proprietary binary format which you can use the native
password functionality (for example you could use Office Automation and the
Excel objects to set this, or the Jet OLEDB Provider I believe can
create/alter Excel spreadsheets and you'd be able to set a password that
way). 

The latter is just a text file with values separated with commas, and records
separated with line breaks. There is no "password" functionality that comes
inbuilt with text files.

Cheers
Ken

--
www.adOpenStatic.com/cs/blogs/ken/ 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Rikter Web Design
: Subject: [thelist] Password-Protect Downloadable Excel Files
: 
: Hi All:
: 
: I'm making available an Excel file for download (using .asp).  This file
: is
: queried from an Access Database.
: 
: I'm familiar with
: <% Response.ContentType = "application/csv" %>
: <% Response.AddHeader "Content-Disposition",
: "attachment;filename=nameoffile.csv" %>
: 
: Question: Anyone know how to enable this password-protected by default?  I
: need to have it require a password to open.
: 
: Thanks in advance for any help you could provide.
: 
: Sincerely,
: 
: Christopher Lee
: www.rikter.com
: E-Mail: support at rikter.com