Get Daily Data from a website and save it locally, Automatically...
Three different Technologies used in this video:
1. Power Query
2. VBA
3. Task Scheduler
If you want a copy of the file I used then here's a link to download it:
www.AcademyTrainingSolutions.co.uk\FTP\Excel\DailyCovidData.xlsm
Remember it will try to run the VBA immediately, so press ESC to come out of the code, and then F11 to look at the VBA code on the workbook.