Home

Excel Macro

DIYer
Occasional Visitor

Hello -

 

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. 

1 Reply

Hi @DIYer !

 

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.

 

 Greets, Eva.

 

 

 

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies