Error send formula by Send hot key

Help Studio
,
1

Hi everyone,

I would like to ask if you could help me with a problem that arises when sending an Excel formula by Send Key, when sending the formula it shows me the following error:

image
image312×548 11.7 KB

Here is the formula:

=VLOOKUP(F"+numeroPrimeraFila+";[PersonasEstructuraComercial.xls]Sheet1!$D$5:$E$35;2;FALSE)

Thanks for the help

2

Usually Formulas have " in them that (maybe in your case) need to be doublequoted?

“=VLOOKUP(F”“”+numeroPrimeraFila+“”“;[PersonasEstructuraComercial.xls]Sheet1!$D$5:$E$35;2;FALSE)”

otherwise I see no no HotKey command…can you be more specific? What Hotkey, what Activity?
Type Into?
Send HotKey?
What input type method?

you can copy:

“=VLOOKUP(F”+numeroPrimeraFila+“;[PersonasEstructuraComercial.xls]Sheet1!$D$5:$E$35;2;FALSE)”

to Clipboard and do : CTRL c / CTRL v via SendHotkey Activity

3

Thank you very much, I will try

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.