Set password in XLS on export

aspless · April 30th, 2008, 03:59 AM

Chaps,

After several hours of searching and head scratching, setting an XLS password on export is eluding me..

The method i am using for the export is -

Code:

filename =  Date() &  "-Results.xls"
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename="&filename&""

I am using some XML to do some basic worksheet protection but really need to password protect it!

There are some solutions out there but none that i can see which would work with ContentType = "application/vnd.ms-excel".

If any of you have a method i'm sure i would not be the only one who would like to know the solution.

Cheers

Aspless

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Jasper Reports Xls export	ashtrash	J2EE	2	April 6th, 2009 04:45 PM
Export data into the xls Sheet Directly without cl	Kali Charan Tripathi	Reporting Services	0	October 9th, 2008 06:40 AM
Password protect XLS using XML	aspless	XML	6	April 30th, 2008 06:17 AM
Export query param from Access form 2 XLS template	gfranco	Access VBA	0	April 14th, 2008 03:19 PM
want to set password	khalid0407	Need help with your homework?	0	July 2nd, 2007 05:59 AM