Intro

Paylook, a big payroll consulting company, needs help automating business applications.

What you will learn

• Primarily:
  • Open applications
  • Automate applications
  • Dynamic selectors
  • Close applications
• Secondarily:
  • String manipulation

Client Name

Paylook

Process Name

Applications

Description

A high-profile payroll consulting company needs your help automating its favorite application.

• Open the Windows Calculator Application (we use this because everyone have it installed and because the solution are the same in simple and advanced applications)
• Make a dynamic solution that
  • Take two numbers from the user (Display input dialog x 2)
  • Make addition of the two numbers using the Windows Calculator
  • Scrape the result and write it in a log message
  • Close the application
• Advanced
  • Read the Excel data
  • Do the calculation for each row and write the result back into the Excel sheet

Hints

• Run application
  • Find the path by looking in C:WindowsSystem32
• Display Input
  • Store it in a variable
• Display Input
  • Store it in another variable
• Click UI element in window to click on C and clear whatever might be on the calculator
• Click UI element in window
  • Make a dynamic selector with the first variable
• Click UI element in window to click the + sign
• Click UI element in window
  • Make a dynamic selector with the second variable
• Click UI element to click the equal sign
• Extract data from window to scrape the result and store it into a variable
• Get subtext to remove the ‘Display is ‘
• Display message to display the result
• Terminate process to close an app

Video Guide