Export to Excel set password and send via email (SQL 2000)

[ChrisDodgson]

I am running SQL 2000.

I have a stored procedure that creates a set of data, which then needs to be put into Excel, the excel spreadsheet password protected and then emailed to a recipient.

I have the sp sorted, and was going to use xp_sendmail to send the spreadsheet to the required recipient. What I'm not sure of is how to automatically set the password. (it can be the same password every time).

Any help would be greatly appreciated.

Many thanks,

Chris

 

[S1002]

Have you tried setting the password inthe excel spread sheet(in tool right mouse and select protection and then select the options required).

 

[ChrisDodgson]

Yes. But I'm trying to find a way of automating this, as the overall process could be producing upto 300 spreadsheets every day.