How do you automatically pull external web data when the URL changes daily? It's a daily report that is linked on our work intranet site. I don't want to have to manually navigate to the address every day to run the macro.
If you have Office 365, you can do that with OneDrive, Excel and MS FLow.
To do this first insert for testing purpose the formula "=TODAY()" in one cell of your first sheet.
Save your workbook.xlsx on OneDrive and close Excel.
Then go into your Office 365 account - start Flow App on the Waffle icon top left.
It works fine with my Onedrive and Excel and I hope that works also at your place then (2nd screenshot). The 3rd action with that Email Notification is only optional, you can edit your flow and delete that 3rd action if you want.