Click cell create sheet

I want to click on the cell to create a sheet. But I still don’t know how. Thanks you.

Hi @sang_hoang

May i know actually what you are trying to do with some inputs and expected output ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

Hi @Pratik_Wavhal
Now I want to click on cell A1 to create sheet2. can you help me

Hi @sang_hoang,

To create the work sheet , you can use this (Add Sheet)below activity.

Regards
Balamurugan.S

Hi @sang_hoang

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

Input :-

Output :-

Excel :-
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 :-
image

Workflow for the 3rd way :-
Practise Solutions for Forum.zip (13.0 KB)

Mark as solution and like it if it helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

hi @Pratik_Wavhal

When the robot runs, it will find the yellow word to click on. The position of this cell is subject to change
image
thanks you.

hi @balupad14

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

Hi @sang_hoang,

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)

2 Likes

Hi @vamsiyeluri
thanks you to care .
However, I just want to click on this yellow box.
This box can be changed as desired.
thanks you.
image

because of . When I click on this box, it will automatically create a new sheet

@sang_hoang,

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…

1 Like

hi all .
you try it .help me
Load production.xlsx (314.3 KB)

hi @Pratik_Wavhal
have a nice day .
I want to click on the color box on the day. But I don’t know how to do it yet. Can you help me ?
image
Load production.xlsx (313.9 KB)