Retrieves the properties of a specified file and saves the information for later use in the project. When you then use the saved information in another activity, you select one of the file properties as input: Size (in bytes), Name (file name including extension), Full Path, Folder (full path to the folder containing the file), Last modified date, Last accessed date, Created date (dates including time), IsReadOnly (TRUE or FALSE), Size in KB.
- File path - Click Browse next to the field and then browse to and select the file for which to retrieve information. Alternatively, you can click Plus on the right side of the field and then, from the menu, choose one of the available options to indicate the path of the file:
- If the activity is inside a For Each File in Folder activity, you can select CurrentFile > Full Path to indicate the path of the file you are currently iterating through.
- Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select a cell that contains a file path.
- Use Saved Value - Select a value in the form of a file path that you previously saved for later use in the project.
- Text - Enter a file path in the Text Builder. To add dynamic paths, you can combine text with Excel formulas selected using the Plus menu in the Text Builder. For example, for a file downloaded daily that includes the current date in the name, you can add the date to the file name using a formula in the default Project Notebook.
- Ask when run - Prompt for a file path when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
- Output to - Click Plus on the right side of the field and then, from the menu, select Save for Later Use to use the output result later in your project as input for another activity. Alternatively, you can select Open in Advanced Editor and enter a VB expression.
- DisplayName - The name displayed for the activity in the Designer panel.
- Path - See File path in the body of the activity.
- Private - If selected, the data used in the activity is not logged by StudioX.
- Output to - See Output to in the body of the activity.
Updated 9 months ago