Sending Query output as password protected XLS

[Stacey]

Hello,
I have searched the forum using various search criteria and can't find anything dealing with this. I also googled it and couldn't find an answer. I want to send query output in an excel format but I want the file to be password protected. It would be the same password each time the file is sent.

Is this possible?

 

[marleymanner1]

You have to do this sort of stuff through VBA stacey, and you will find how to do it in the Excel help files of VBA. Try to start there.