I want to click on the cell to create a sheet. But I still don’t know how. Thanks you.
May i know actually what you are trying to do with some inputs and expected output ??
Er Pratik Wavhal
Now I want to click on cell A1 to create sheet2. can you help me
To create the work sheet , you can use this (Add Sheet)below activity.
May i know how you are going to click on Cell A1 ??
Means by yourself only u are going to click on Cell A1 Right ??
If Yes then,
Below is the Excel with Macro Enable
After clicking on Cell A1 that is the blue button der, the new sheet will get created
New Microsoft Excel Worksheet.zip (11.1 KB)
One more VBA Code I have made which will automatically Create new Sheet after running the uipath workflow but not by clicking anywhere :-
Practise Solutions for Forum.zip (48.1 KB)
Here is the 3rd way by which the workflow itself will opens that particular Excel and will click on that Retrangular Button which is der on Cell A1 and after clicking that button new sheet will get create :-
Workflow for the 3rd way :-
Practise Solutions for Forum.zip (13.0 KB)
Mark as solution and like it if it helps you
Er Pratik Wavhal
When the robot runs, it will find the yellow word to click on. The position of this cell is subject to change
When the robot runs it will find the yellow word to click on. The position of this cell is subject to change.
how to click on this yellow box.
I have made a simple video how to create an excel sheet when you clicked on excel cell. go through this video then you will able resolve your query. Create_Sheet.xaml (21.8 KB)
thanks you to care .
However, I just want to click on this yellow box.
This box can be changed as desired.
because of . When I click on this box, it will automatically create a new sheet
I have clearly explained how to create dynamic sheet when you click on particular cell (yellow box or what ever cell )in attended mode automation…How ever you don’t want to do attended automation, if you know the particular cell address then you can read cell activity to create sheet in unattended automation…
hi all .
you try it .help me
Load production.xlsx (314.3 KB)