From the course: Blue Prism: Excel Automation

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Generate file path

Generate file path - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Generate file path

“

- [Instructor] Next, we'll start with building the logic for the consolidation report page. Navigate to the Create Monthly Report page where we'll start with building the components. The first action from this page will be to generate the file path of the consolidation report. We will use a Calculation stage for this purpose. Once created, double-click in order to open the expression window. The first thing we'll do will to rename the action to Generate File Path. When it comes to the expression itself, we'll need a few elements to build the correct filename. The filename will not only contain the name of the file, but also the full path plus the file extension in order the file to be both created and located. The filename will be a combination of the following components. The environment variable we created in the previous chapter, which is the Consolidated Reports Folder, the Folder Name where the file will be saved,…

Contents