Excel Macro - change the layout of Pivot table

[Chen_Kenny (Kenny J)]

Hi Everyone, need your help,
I tried to use “Invoke VBA activity” to automatically change Pivot table layout.
The Pivot tables name is same as sheet name. But no working…
If I created the Macro and copy paste, the code is work. BTW I want to use Uipath to automatically using macro in the excel files that don’t have Macro (.xlsx)…