Providing Password Protection to Excel Reports for Distribution in Emails
This paper is meant to provide a way to password protect the excel output generated from a BO report and then distribute it. It is done is without using third-party add-ins to the BusinessObjects installation. This method makes use of VBA for excel and does not modify the installation by any means. The main objective is to provide another authentication level to the attachment sent by emails so that any accidental email if sent to a non-intended person doesn't compromise the confidential data.