From the course: Introducing Blue Prism

Import Excel VBO - Blue Prism Tutorial

From the course: Introducing Blue Prism

Start my 1-month free trial

Import Excel VBO

- [Instructor] We can now move on completing the Get All Orders page. You can see that part of the functionality has already been built with two actions. One to navigate to All Orders page in Airtable and another one to download the orders. We can minimize this part of the screen in order to see what's actually happening on Airtable. We'll set the next stage at the start and then use the Step Over button in order to go through the next two stages. We'll navigate to All Orders and download them. You can see the CSV file downloaded in the bottom. For the next few steps of the process we're going to require to extract the information from the Excel into Blue Prism. For this purpose, we're going to require to import the Excel VBO into Blue Prism. For this purpose, we're going to click on File, Import, Browse, and depending on what version of Blue Prism you have we need to navigate to Program Files, Blue Prism Limited, Blue Prism Automate, and VBO. You can see there is a wide range of visual basic objects, which are available to you. We're looking for the MS Excel VBO and in order to import it, we're going to double click on the file. We're going to click on Next and Finish. You can see the newly imported object is now available.

Contents