Send HotKey ctrl-F to excel does nothing

excel
uiautomation
activities

#1

I have tried seemingly every variant I can think of in target, etc. It should open the find dialog and does if I do it manually but everything I try won’t let the robot do it. this is on excel on the same computer that the uipath studio community edition is running on.CompanyList.xlsx (8.7 KB)
Main.xaml (18.3 KB)


Copy last column and insert new in excel with formatting
Hot key down arrow
#2

Give a try with lower case f (ctrl f)


#3

I find using “Type Into” works better, but that’s just me.
You can do “[d(ctrl)]f[u(ctrl)]”

EDIT:
You can also add in the string to find like
"[d(ctrl)]f[u(ctrl)]word[k(enter)]"

I also use this for all the menu items like coloring and formatting cells with the Alt keystroke combinations that show up when you press Alt in Excel.


#4

Thank you both. Both answers worked great. Funny that I saw capital F in the hover over hot key suggestion in excel and it really didn’t occur to me that I was never typing the shift so it was really a lower case f I was using.

where do you find the syntax for the type into codes for special keys? I figure [] bracket the special key but what is the d and u and k ??


#5

I’m not sure of all the syntax that is available with keystrokes but “k” is for keypress, “d” is for down-keypress, and “u” is for up-keypress.

So if all you want is to press the key then use “k”, if you need to hold it down then use “d” before and “u” after.


#6

As a personal advice- if u wanna consider then please only use type into activity for Hot key pass purpose with Citrix Environments. Always better to use Send Hot key if you are dealing with non-citrix environments.

Regards…!!
Aksh


#7

@ClaytonM Hi Clayton and hi everyone,

I’m trying to execute an excel macro from inside UiPath. I’m at my wit’s end and not sure what to do anymore.

The key command to execute it in Excel is ctrl+shift+v. When I send the command all I see in the Excel file is “v”. The macro is not executed.

Also, using the execute macro thing hasn’t worked for me either.

PLEASE HEEEEELLLPPPPP!!!


#8

Hi. I would highly recommend you get the Execute Macro working if your automation approach is with VBA. But if you want to perform hotkeys, then one issue I run in to is that the “ctrl”, “shift” and “alt” keys don’t execute unless you have have some delay infront when trying to perform right after the Excel file is opened or right after other hotkey combos (like for example set the Delay Before to like 500 or so)

Regards.


#9

Screenshots.pdf (107.8 KB)

Hi Clayton,

I did as suggested but it didn’t work. I’ve attached a screenshot of how I used the send hotkey command. I also tried it without using “indicate on screen”. I just need to be able to pass the “ctrl+shift+v” command into an excel file. However I can achieve it, please let me know.

I also tried using the Execute Macro command but it returned the error message in the second attachment.

Is there a way to reach you please? I’m trying to complete a proof of concept as a demonstration in order to get management to authorize formal training and possibly onboard UiPath. Can I please inbox you my number somehow? Please. Thanks


#10

I would need to see more like the properties or the workflow. Feel free to send me direct messages through Mail on these forums. Regards.