EXCEL Set workbook property function

This article describes the RPA Excel functionality to set a workbook property.

For a full list of available functions, please read EXCEL functions.

Description

The Set workbook property function writes a value to a document property on the workbook. These properties are metadata fields embedded in the file, visible in File → Info in Excel. Setting properties is useful for tagging processed files with audit information.

Available properties

Setting it up

To use the Set workbook property function, follow these instructions:

{{popups:rpas/add:action=excel-set-property}}

Once on a process map:

1. Navigate to the process where you would like to add the function
2. Click on the green button’s drop-down
3. Click on “+ Activity”
4. Select the EXCEL Set workbook property option
5. Click "Add" once you are done

Input parameters

Output

This function does not return a value. The property is set on the workbook. Remember to save the workbook for the change to persist.

Tips

• Use this to stamp processed files with metadata – e.g. set Comments to "Processed by RPA on {date}"
• Set Keywords for easy searching in file explorers and document management systems
• Remember to save the workbook after setting properties

Related functions

• Get workbook property
• Save workbook