Error send formula by Send hot key

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:

Here is the formula:

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

Thanks for the help

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

Thank you very much, I will try

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