We have fired up Excel, but we have yet to open the ShoppingList_Henry.xlsx file. Let's get to it now by observing the following steps:
- With the Get List of items to purchase page opened, drag an Action stage and drop it beneath the Show stage. Configure it as follows:
- Name: Open List
- Business Object: MS Excel VBO
- Action: Open Workbook
- In the Inputs tab of the Open List stage, the action is expecting two inputs: handle and File name.
- In the handle field: Drag the handle data item that was created when we created an instance of Excel in the handle field.
- In the File Name field: Drag the Shopping List Excel File Path data item that we created earlier to contain the file path to the Excel file (which contains the actual path, C:\Shopping\ShoppingList_Henry.xlsx).
- Click Outputs. In Workbook Name, click on the Data item icon to automatically create...