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 -
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.