Get Sheet Name & Put in Read Range Activity "Sheet Name"

Hello smart people,

I have a workbook with several sheets, every month the sheet names and the amount of sheets will be different. And I need to copy all range (use read range and write range) in each sheet.
Therefore, I need to get the the sheet names first and then put the sheet names in Read Activity.
I have already know how to get sheet name by assign and for each activity. It successes!
But how to use every sheet names in Read activity? Thank you.

@irene1018b Use Read Range activity and use item in place of sheetName

Hi @irene1018b,

In For Loop workbookvariable.GetSheets.** using Excel Application Scope

Pass item Values in Read Range Activity


Let me known