Create Pivot Table using invoke VBA activity in Uipath

Help
1

Hi all,

Want some idea on the below scenario.

I have n number of excel files in one folder. For each excel file in that folder, I want to create pivot table.
For that, i took the first excel file of the folder and recorded the macros for the pivot table creation and saved the macros in a text file, so that can be used in the Invoke VBA activity under the excel application scope activity. So the Invoke VBA activity that has the macros in a text file works fine for only that particular first excel file of that folder.

But I want to make it work for all other excel files in the folder. Please help me out here !
Attached the sample xaml and also the macros recorded for the first excel file.

Pivot-1.txt (3.4 KB)

[Main.xaml|attachment]
(upload://uc0jVqOFOfMwZPKRUHiO8D3sTJ7.xaml) (6.7 KB) for you reference.

Thanks,
Hirunyaa. RMain.xaml (6.7 KB)