Intro

Always being automatically updated with currency rates is important and a perfect case for Microsoft Power Automate Desktop. Here’s how to do it.

Learning Objectives

  • Geting started with Power Automate Desktop
  • Automate browser work
  • Automate Excel

Description

  • Download the Excel book for the case
  • Inspect the data in the sheet named “1. US dollars”
    • We want to fill in C2 and D2 – Date and Rate for US dollars
  • ¬†Create a robot in Power Automate Desktop, that
    • Navigate to https://nationalbanken.dk/en
    • Click “More currencies”
    • Scrape the US dollar rate and the date for the rate
    • Write the results back to Excel

Hints

  • Creating a variable for the project path is best practice
    • It’s then easy and robust, when we choose to more the folder

Video Guide