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.

Open weekly report

Open weekly report - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Open weekly report

- [Instructor] As we now have all stages required for creating the consolidated report, we can move into completing the Get Weekly Data page. Before we proceed, we need to make sure the Weekly Report Files collection is set as a global variable so we can access it from the Get Weekly Data page. So navigate to the Create Monthly Report page and double click on the Weekly Reports Files collection. Make sure you un-tick the "Hide from other pages in the process" option and click on okay. As in every Excel interaction, we need to create a reference to the Weekly Report before opening it. We will navigate back to the Get Weekly Data page and create a new action in the MS Excel VBO. Double click on it in order to rename it to Create Instance. Similarly to before, we are going to select the MS Excel VBO from the business object. And when it comes to the action, we're going to select the Create Instance. The Enable Event…

Contents