You’re offline. This is a read only version of the page.
This is a brief introduction on how to create a Power Automate Desktop flow to run excel macro.
1. Open Power Automate Desktop and click the "New flow" at the top left of the screen.
2. Give your flow a name and then click the "Create" button to create the flow.
3. In the flow edit screen find "Excel" in the Actions area, click on it to show all the actions that are related to excel, then drag the "Launch Excel" action to be the first action of the main flow.
Alternatively, you could directly type in the name of the action in "Search actions" area and search for it.
4. In the setting of "Launch Excel" action, choose "and open the following document" for "Launch Excel:" parameter and then select your excel. In advanced section, switch on "Nest under a new Excel process" and "Load add-ins and macros", then click "Save" to save all your settings.
5. Go back to the Actions area, under Excel→Advanced, find the "Run Excel macro" action and drag it to the main flow to be the second action. You could also directly search for this action from the "Search actions" area
6. In the setting of "Run Excel macro", in put the name of the macro you want to run, then click save.
7. Click the run button to run your flow.
For more detailed information, please refer to the link below:
https://learn.microsoft.com/en-us/power-automate/desktop-flows/how-to/run-macros-excel
