Example 1: Password Protect a Single Excel Document
Example 1: Password Protect a Single Excel Document
Follow the steps below to password protect an Excel document.
From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Password Protect Excel task to the Project Outline.
On the Basic tab of the Password Protect Excel task, specify values for the following attributes:
Source File
Specify the path and file name of a single file to be password protected.
Destination File
Specify the path and file name where the file will be created with password protection.
Password
Specify the password to protect the Excel file.
When the user attempts to open the Excel file, a Password prompt appears. Enter the password from step 3 above and click OK.