I am trying to use power automate to launch an excel sheet and refresh a Pivot table using a VBscript. The power automate flow will launch the excel and set the active sheet but then I want to run a code that resfrshes the pivot table on the active sheet.
See the failed code I currently have in the screenshot below. Am i missing something or is there another set of code I should be using.
