davidgalaxy

Hello everyone essentially what i'm doing here is copying a cell from excel, switching to another application, pasting it. then switching back and sending a right arrow key command to go to the next cell and repeat until it detects "STOP" in the clipboard. then at the end of the macro it goes left left down to reset the position for a new line, and the macro repeats i have been tinkering around with adding delays and such but for some reason it is skipping lines in excel, but everything else is behaving properly for example it is SUPPOSED to go, right, right, then left left down to go to the beginning of the next line but instead it goes right, down right, right, left left down i verified my script and there is no down right command but it is doing it anyway. Does anyone have any idea what might cause this? I have attached my script Repeat Start (Repeat 50 times) If Clipboard Contains "STOP" Macro Stop End If Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Delay 150 Milliseconds Text Type: <ARROW RIGHT> Delay 150 Milliseconds Activate Window: "Toy Galaxy" Delay 150 Milliseconds Clipboard Paste Text Type: <ENTER> Delay 150 Milliseconds Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Delay 150 Milliseconds Text Type: <ARROW RIGHT> Delay 150 Milliseconds Activate Window: "Toy Galaxy" Delay 150 Milliseconds Clipboard Paste Text Type: <ENTER> Delay 150 Milliseconds Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Text Type: <ARROW LEFT> Delay 150 Milliseconds Text Type: <ARROW LEFT> Delay 150 Milliseconds Text Type: <ARROW DOWN> Delay 150 Milliseconds Activate Window: "Toy Galaxy" Delay 150 Milliseconds Text Type: <CTRLD><SHIFTD><ARROW RIGHT> Text Type: <CTRLU><SHIFTU> Delay 150 Milliseconds Clipboard Paste Text Type: <ENTER><ENTER> Delay 150 Milliseconds Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Repeat End Here is the script without all the delays Repeat Start (Repeat 50 times) If Clipboard Contains "STOP" Macro Stop End If Activate Window: "OpenOffice.org" Clipboard Copy Text Type: <ARROW RIGHT> Activate Window: "Toy Galaxy" Clipboard Paste Text Type: <ENTER> Activate Window: "OpenOffice.org" Clipboard Copy Text Type: <ARROW RIGHT> Activate Window: "Toy Galaxy" Clipboard Paste Text Type: <ENTER> Activate Window: "OpenOffice.org" Clipboard Copy Text Type: <ARROW LEFT><ARROW LEFT><ARROW DOWN> Activate Window: "Toy Galaxy" Text Type: <CTRLD><SHIFTD><ARROW RIGHT> Text Type: <CTRLU><SHIFTU> Clipboard Paste Text Type: <ENTER><ENTER> Activate Window: "OpenOffice.org" Clipboard Copy Repeat End The weird thing is that it was working before I added the loop, and it worked one line per macro run If anyone could possibly help it would be VERY MUCH APPRECIATED!!!! Thanks!!

Hello everyone essentially what i'm doing here is copying a cell from excel, switching to another application, pasting it. then switching back and sending a right arrow key command to go to the next cell and repeat until it detects "STOP" in the clipboard. then at the end of the macro it goes left left down to reset the position for a new line, and the macro repeats i have been tinkering around with adding delays and such but for some reason it is skipping lines in excel, but everything else is behaving properly for example it is SUPPOSED to go, right, right, then left left down to go to the beginning of the next line but instead it goes right, down right, right, left left down i verified my script and there is no down right command but it is doing it anyway. Does anyone have any idea what might cause this? I have attached my script Repeat Start (Repeat 50 times) If Clipboard Contains "STOP" Macro Stop End If Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Delay 150 Milliseconds Text Type: <ARROW RIGHT> Delay 150 Milliseconds Activate Window: "Toy Galaxy" Delay 150 Milliseconds Clipboard Paste Text Type: <ENTER> Delay 150 Milliseconds Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Delay 150 Milliseconds Text Type: <ARROW RIGHT> Delay 150 Milliseconds Activate Window: "Toy Galaxy" Delay 150 Milliseconds Clipboard Paste Text Type: <ENTER> Delay 150 Milliseconds Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Text Type: <ARROW LEFT> Delay 150 Milliseconds Text Type: <ARROW LEFT> Delay 150 Milliseconds Text Type: <ARROW DOWN> Delay 150 Milliseconds Activate Window: "Toy Galaxy" Delay 150 Milliseconds Text Type: <CTRLD><SHIFTD><ARROW RIGHT> Text Type: <CTRLU><SHIFTU> Delay 150 Milliseconds Clipboard Paste Text Type: <ENTER><ENTER> Delay 150 Milliseconds Activate Window: "OpenOffice.org" Delay 150 Milliseconds Clipboard Copy Repeat End Here is the script without all the delays Repeat Start (Repeat 50 times) If Clipboard Contains "STOP" Macro Stop End If Activate Window: "OpenOffice.org" Clipboard Copy Text Type: <ARROW RIGHT> Activate Window: "Toy Galaxy" Clipboard Paste Text Type: <ENTER> Activate Window: "OpenOffice.org" Clipboard Copy Text Type: <ARROW RIGHT> Activate Window: "Toy Galaxy" Clipboard Paste Text Type: <ENTER> Activate Window: "OpenOffice.org" Clipboard Copy Text Type: <ARROW LEFT><ARROW LEFT><ARROW DOWN> Activate Window: "Toy Galaxy" Text Type: <CTRLD><SHIFTD><ARROW RIGHT> Text Type: <CTRLU><SHIFTU> Clipboard Paste Text Type: <ENTER><ENTER> Activate Window: "OpenOffice.org" Clipboard Copy Repeat End The weird thing is that it was working before I added the loop, and it worked one line per macro run If anyone could possibly help it would be VERY MUCH APPRECIATED!!!! Thanks!!