Doing VAT lookups on a web page is a typical RPA case. Here’s how to solve it.

Learning Objectives

  • Read and write in Excel
  • Web searches
  • Web scraping


  • Download the Excel book with sample data
  • Navigate to and click on English in the upper right corner
  • For each row
    • Do a CVR lookup at
    • Fill in the blank columns (except status) by doing a web scrape of the CVR lookup page
    • Write the result back to Excel
  • Error handling
    • Try to add a row in the Excel sheet with the CVR 12345678. Handle the error.
    • Log column: Write either Succesful or Failed


  • Use an On block error activity for the error handling

Video Guide