How to get array from config file and input by invoke VBA method?

[WWM (Wayne Wang)]

Hi everyone, I’m filtering a pivot table by invoke VBA method in UiPath.
My VBA code is working.
But my purpose is to make this file more user-friendly.
So I’m trying to write dynamic array values in config file.
But the pivot table filter doesn’t work. Attachment is my files.

Any solution to this?
Thank you all in advance!

Config.xlsx (9.4 KB) InitAllSettings.xaml (25.3 KB) Main.xaml (8.5 KB) PivotFilter_Test.txt (2.4 KB) Test.xlsx (13.7 KB)

[AshwinS2 (Ashwin S)]

Hi @WWM

Try this

Create Pivot Table

Thanks
Ashwin S

[WWM (Wayne Wang)]

Hello, @AshwinS2
Thanks for you reply. I have already known this activity. But it didn’t meet my requirements.
Actually I figured it out and it is working now.
According the topic below. @tomato25 provide some useful clue. Thanks, bro.

Number of Parameters specified does not match the expected number