Run Excel Macro using Power Automate Desktop

Question

I am trying to Run an Excel Macro using Power Automate Desktop that refreshes all queries.

The problem is that power automate refuses to do it. I have watched every Youtube video about this topic, but can't seem to make it work.

Steps and Settings:

1. Launch excel

2. Run Excel Macro

3. Close excel

Macro:

Sub Refresh()

    ActiveWorkbook.RefreshAll
End Sub

I literally don't know what I am going wrong. The macro itself works.

I have tried playing around the name, including the Module name, workbook name, putting it in double, single, triple quotes, using ".", ";", "-" as delimiters etc. Literally, what is wrong here? It's probably the easiest fix ever but, where exactly have I made a mistake?