Follow the steps below to password protect a set of Excel files.
From within the Project Designer page, expand the File System folder in the Component Library, and then drag the Create File List task to the Project Outline.
On the Basic tab of the Create File List task, specify values for the following attributes:
File List Variable
The name of a variable that will contain the list of files being created. If this variable exists it will be overwritten, otherwise it will be created.
Click the
Add
button. This displays a sub-menu of “Action” items that can be performed.
Choose the
Add a File Set
option from the sub-menu.
On the Basic tab of the File Set option, specify values for the following attributes:
Base Directory - The starting directory for this File Set. If no filters are defined, all files in this directory will be included.
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 Files Variable
Specify the name of a variable of type File List which contains the files to password protect. For example, ${fileList}.
Destination Directory
Specify the directory to which the specified source files should be placed after they are password protected. You must specify this attribute if you are password protecting multiple files using one or more File Set elements, or a Source Files Variable.