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.
Use Select Range activity.
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?
If you do not want to use all these activities then you have to use Macro’s only.
Is it necessary that I should use Visual Basic when I use Macro?
Please try Get Workbook sheets activity then you will be getting all the sheets in a list then you can loop the list.