"Special Keys" coming through as key strokes in excel

[Tom Jordan]

I'm using two variables in a single loop, so I am using the excel command and the multiple cells option.

In my application, the variables are being used with the Keystrokes command. Everything seems to work fine if my variables only contain individual key characters, however if I try to include "Special Keys", they get converted to individual key characters and the "Special Keys" do not execute.

I am able to pass "Special Keys" using a list file. How do I pass them using excel?

Thanks for your thoughts on this.

[forumsupport]

Hello,

You can use Excel: Get Cells command to get the special keys from an excel cell and then use loop until there is no blank row in excel. That way your task will work as expected plus you don't need to fix up the rows. The task would loop through all the available rows in spreadsheet.

The text format of commands would appear as follows,

Excel : Open Spreadsheet "C:\Book1.xls". Active Sheet: Default. Session: Default
Excel : Go to cell "A1". Session: Default
Excel : Get value of Active Cell and assign to variable "Prompt-Assignment". Session: Default
Open "notepad.exe "
Delay: (500 ms)
Keystrokes: Automation Anywhere testing[ENTER] in "Untitled - Notepad"
Delay: (500 ms)
Loop While $Prompt-Assignment$ Not Equal To ""
Keystrokes: $Prompt-Assignment$ in "Untitled - Notepad"
Delay: (500 ms)
Excel : Go to one cell right of active cell . Session: Default
Excel : Get value of Active Cell and assign to variable "Prompt-Assignment". Session: Default
Keystrokes: $Prompt-Assignment$ in "Untitled - Notepad"
Delay: (500 ms)
Excel : Go to one cell below the active cell . Session: Default
Excel : Go to beginning of the row of the active cell . Session: Default
Excel : Get value of Active Cell and assign to variable "Prompt-Assignment". Session: Default
End Loop


We have also attached a sample task for your convenience. To run this task,

. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy Book1.xls under C:\.

Note: Automation Anywhere 5.5 is required to run this task. You can download free version of Automation Anywhere 5.5 from our website:
Automation Anywhere - The Leading Automation Software

Hope that helps.

[Tom Jordan]

This should help. Thank you for the quick reply!