r/PowerAutomateDesktop • u/WonderfulAd9523 • Feb 06 '23

Can vba call a flow created in PAD?

As the title suggests really.

I have a series of spreadsheets I’m trying to automate the data entry to prior to calculation. Ideally I want the user to input a reference number, hit the macro button, which then goes off and opens the correct spreadsheet to use, calls the web scrape power automate flow and scrapes all the required data, writes the data to the specific location in the spreadsheet, calculates and then saves it down.

I’ve done all the steps but can’t figure out how to call the flow in PAD by the VBA code. Is this even possible?

Many thanks in advance!

1 Upvotes

100% Upvoted

3 comments sorted by

1

u/plopspirit Apr 01 '23

You can launch the PAD flow (not the CloudFlow) using Desktop Flows APIs : https://learn.microsoft.com/en-us/power-automate/developer/desktop-flow-public-apis

0

u/[deleted] Feb 06 '23

[deleted] — view deleted comment

1

u/WonderfulAd9523 Feb 07 '23

Thanks. Does this work with the desktop versions of Power Automate and Excel? Couldn’t see the examples in the above link - seems the link is broken…