Run macro and send out results without user opening spreadsheet

[bark01]

I have a spreadsheet set up that when it opens, runs a macro that copies and pastes old data, then runs power query to import new data. I then have 2 tables one to show the new data nad one to show th deltas from the old data.

Is there a way to automate this so it happens every day without any interaction from me? I have power automate and he used it to run thing in the cloud before but I'm unsure if it will open spreadsheets and run macros in the cloud.

 

[frank_AL]

Just doing a Google search it appears you could use Microsoft's 'Task Scheduler' to open the file as a set time.