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