Selecting excel sheets without using Read Range

Is there any way where I can select a particular sheet without using Read Range because the project that I am working right now requires the automatic detection of sheets then execute all the necessary process for each sheet? Thank you in advance for any help.

@ROBERT_RUSSELL_MONSA

Use Select Range activity.

1 Like

I try to copy this number “6” to another excel file which is highlighted in the given picture. How can I do that without using Read Range, Read Cell, Write Range, or Write Cell?

@ROBERT_RUSSELL_MONSA

If you do not want to use all these activities then you have to use Macro’s only.

1 Like

Is it necessary that I should use Visual Basic when I use Macro?

Hi @ROBERT_RUSSELL_MONSA

Please try Get Workbook sheets activity then you will be getting all the sheets in a list then you can loop the list.

1 Like