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

Help
,
1

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.
image
image
image

2

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

3

Hi @irene1018b,

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

Pass item Values in Read Range Activity

image

Let me known

Thanks,
Neelima