How to work on sheets of single excel file one by one

[joshikalyani]

Hi,

I'm working on a excel workbook having different sheets. I wanted to perform same action on each sheet & save output.

I'm not sure how can i input single file & use all sheets one by one to action on them.

[binuacs]

@joshikalyani Use the batch macro to combine all your sheets and apply the action on each sheet. Sample attached

[joshikalyani]

Showing error at macro "Error Get_Sheets_Info (11): The Control Parameter "Control Parameter (4)" must be mapped to a field."

Also this workflow collating data, but i want to action each one of the sheet one by one. e.g. i want to apply pivot on each sheet

[joshikalyani]

screenshot of error

[binuacs]

@joshikalyani update the control parameter like the below image

[joshikalyani]

still error, I've changed the input file

[binuacs]

@joshikalyani Can you screen shot the macro action tool settings? 

[joshikalyani]

[binuacs]

@joshikalyani Check the below tool configuration

[joshikalyani]