Hot key's or type into

Help
,
1

Hi All,

I am trying to perform ctrl+c using type into activity as hot keys are not working fine in excel, can anyone tell me what is the mistake I am doing. I have attached the screen shot.
I want to copy a specific range from one excel sheet to other, even alternate solution is also fine but I want to avoid data tables.

Capture11
Capture11778×446 11.6 KB

Thanks in advance
Regards,
Hari

1 Like
2

“[d(ctrl)]c[u(ctrl)]”

:slight_smile:

4 Likes
3

Hi, how can I type in ‘enter’?

4

Use send hotkey activity.

5

image
image1346×245 10.3 KB

I tried but it’s putting the formula in only

6

Did you try type into?

7

yup I did

8

Try tab. If that din’t work can you please share sample file and your requirement so that I can help out .

Thanks,
Hari

9

2808 - v5.6 - Copy - Copy.xaml (202.2 KB)

10

image
image773×414 11.4 KB

With out excel file i cannot review the code and also it showing some error because of the different versions of UIpath we both are using.

11

It was for each activity. I am using 2018.3 version

image
image715×723 16.1 KB

image
image752×725 18.7 KB

12

@sangasangasanga Can you tell me the reason for using enter key there?

13

The formula is entered in the cell but not executed.

14

@sangasangasanga Usually when u entered formula using it will be executed automatically no need of enter hot key is required in your case.

And in your case writing to cell works in background after that you have given enter hot key, in this situation hot key will be no use, since hotkey works on only opened and active windows. That makes your hot key invalid in your case.

15

The hot key wa suggested to me to try.

Yup but it’s not doing that

16

@sangasangasanga Usally formula will be executed automatically, i used couple of times vLookup. Check the your formula thoroughly might be mistake in ur formula.

If u really want to use hot key in this case, inside application scope use both write cell and send hot key activity. Hot key may require selector so use attach window for it or use selector directly in send hot key. Try with out selectors once if doesn’t work then use selectors.

1 Like
17

this is my formula
“=VLOOKUP(A”+pos+“,‘C:\Users\IHL2016\Documents\UiPath\Project2[ServersFromPDF.xlsx]AllServers’!$A$2:$A$150,1,FALSE)”

i will try your other suggestion and let you know

18

@sangasangasanga If Project2 is folder name give backslash like other folders in the path u have mentioned.

1 Like
19