View Full Version : Sending Query output as password protected XLS


Stacey
11-12-2008, 05:38 AM
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
11-12-2008, 07:04 AM
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. :)