Excel Arrow Keys

[des1]

I am having trouble doing something that I though should be simple, but Excel is not responding properly.  All I need to do in Excel is Paste from the Clipboard, the do the keystrokes below, except the macro will not do anything after it pastes the contents.

PASTE Contents then
{F2}
{LEFT}
{LEFT}
.
{HOME}
-
{ENTER}
Thanks,
D-

[Oleg]

I'm afraid that you are wrong.
In order to paste from clipboard use Ctrl-V key combination.

F2 call edit mode in selected cell in Excell

[Oleg]

Also, see clipboard actions

[des1]

That is exactly what I am doing.  It will not "edit" the cell and move the arrow over two spaces, insert a period, then Enter to save the data after pasting the data.
;**********************
;* RoboTask Task file *
;* Do not edit!       *
;**********************
 
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|1983895906
ContinueOnError=INTEGER|0
Events=FOLDER
ExternalName=STRING|"Task6"
Hide=INTEGER|0
ID=INTEGER|1529657606
Name=STRING|"Paste..."
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
[Actions]
Action1=FOLDER
Action2=FOLDER
[Actions\Action1]
ActionID=STRING|"A_CLIPBOARD_PASTE"
Enabled=INTEGER|-1
Name=STRING|"Paste"
Params=FOLDER
[Actions\Action1\Params]
mode=STRING|"1"
[Actions\Action2]
ActionID=STRING|"A_GENERAL_SENDKEYS"
Enabled=INTEGER|-1
Name=STRING|"Send keys to active window"
Params=FOLDER
[Actions\Action2\Params]
currentwindow=STRING|"1"
fixedwindow=STRING|"1"
keylayout=STRING|"0"
keys=STRING|"{F2},{LEFT},{LEFT},.,{HOME},-,{ENTER}"
sendkind=STRING|"0"
wincaption=STRING|"Notepad"
[Events]
Event1=FOLDER
[Events\Event1]
Enabled=INTEGER|-1
EventID=STRING|"E_GENERAL_HOTKEY"
Params=FOLDER
[Events\Event1\Params]
hotkey=STRING|"16437"
 
 

[Oleg]

I see.
I think that you want to do exactly the following:
- turn on the edit mode
- insert into cell the data from clipboard
- put the "dot" at two symbols from end of the string
- put the "minus" at the beginning of the string
- save the cell

You should use the such string in "Send keystrokes":
{F2}^(V){LEFT}{LEFT}.{HOME}-{ENTER}

Do not put the line feed into this string, because each line feed simulates the pressing of Enter key. Ctrl-V combination (^{V}) force the pasting from clipboard

see the task below:

;**********************
;* RoboTask Task file *
;* Do not edit!       *
;**********************

[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|1614811947
ContinueOnError=INTEGER|0
Events=FOLDER
ExternalName=STRING|"Task409"
Hide=INTEGER|0
ID=INTEGER|1529657606
Name=STRING|"Paste... (improved)"
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3

[Actions]
Action1=FOLDER

[Actions\Action1]
ActionID=STRING|"A_GENERAL_SENDKEYS"
Enabled=INTEGER|-1
Name=STRING|"Send keys to active window"
Params=FOLDER

[Actions\Action1\Params]
currentwindow=STRING|"1"
fixedwindow=STRING|"1"
keylayout=STRING|"0"
keys=STRING|"{F2}^(V){LEFT}{LEFT}.{HOME}-{ENTER}"
sendkind=STRING|"0"
wincaption=STRING|"Notepad"

[Events]
Event1=FOLDER

[Events\Event1]
Enabled=INTEGER|-1
EventID=STRING|"E_GENERAL_HOTKEY"
Params=FOLDER

[Events\Event1\Params]
hotkey=STRING|"16437"

[Oleg]

Also you can simply remove line feeds from "sending keystrokes" in your task.
Write this:
{F2}{LEFT}{LEFT}.{HOME}-{ENTER}