102 - Using PAD and PowerShell to execute VBA
Showing how to use Power Automate Desktop or PowerShell to open an Excel file and run a macro inside. This avoids having to open the program, waiting, enabling macros and clicking the button/having the macro run when you open the file.
As a bonus, the video also shows how to run a macro that takes an input argument.
00:37 Run Excel VBA with Power Automate Desktop
01:11 Adding an argument
01:59 PowerShell
02:58 The script
04:07 Current time in PAD
04:21 Changing the flow
04:27 Pass variable into PowerShell
04:35 Fixing errors
05:44 Full run
05:49 PowerShell Output-variable