The activity is added to the Designer panel. Because each row contains data about an employee, it will be known in the automation by the name Employee to make it easier to select data from it later in the automation.Ĭlick Add activity inside For Each Excel Row, and then find the Type Into activity in the search box at the top of the screen and select it. You have indicated that you want to repeat activities for each row in Sheet1 of the EmployeeData file. Click Plus on the right side of the In range field, and then select EmployeeData > Sheet1.Step 3: Add activities to repeat for each row in the Excel file.Ĭlick Add activity inside Use Excel File, and then find the For Each Excel Row activity in the search box at the top of the screen and select it. You have indicated that you will work with the file Employees.xlsx that is known in your automation as EmployeeData. In the field Reference as, enter EmployeeData.Click Browse next to the Excel file field, and then browse to and select the file Employees.xlsx.You have indicated that you want the automation to open the file EquipmentAgreement.pdf in Adobe Acrobat.Ĭlick Add activity inside Use Application/Browser, and then find the Use Excel File activity in the search box at the top of the screen and select it. In the Text Builder, enter EquipmentAgreement.pdf. Click Plus on the right side of the Application Arguments field, and then select Text.The Use Application/Browser activity is updated, a screenshot of the window appears inside the activity, and the path to the executable file appears in the Application Path field. When the window is highlighted in blue, click anywhere inside it. Click Indicate Application, and then move the mouse pointer to the Acrobat window where the PDF is opened.You have indicated that you want to create a folder named EquipmentAgreements in the project folder.Ĭlick Add activity below Create Folder, and then find the Use Application/Browser activity in the search box at the top of the screen and select it. In the Text Builder, enter EquipmentAgreements. In the Create Folder activity, click Plus on the right side of the Folder name field, and then select Text. Step 2: Create a folder and add the files to the project.Ĭlick Add activity in the Designer panel, and then find the Create Folder activity in the search box at the top of the screen and select it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |