automate password protection of excel

[mayash]

I'm looking for a way to password protect the excel spreadsheets currently created in a send object macro w/i access.

Currently, I use a macro to open a report based on a query filter. Then I use send object to send the report in excel via email.

I'm looking for an automated way to password protect the excel files before sending them out via email.

Thanks!

 

[Monkey Man]

I don't think it's possible just through a macro. You could use the Output to command to export the table to a file in the temporary folder, then use a VBA procedure (which you can call from the macro after you have exported the file) to open up the file, set the password and then e-mail.......

But I could quite easily be very wrong.....

Apologies,

Jordan