davidgalaxy Posted November 16, 2010 Report Share Posted November 16, 2010 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!! Quote Link to comment Share on other sites More sharing options...
gene2 Posted November 17, 2010 Report Share Posted November 17, 2010 I believe there might 2 way this might be easier. 1. If you know VBA for excel? You can do all of this in VBA and Excel and have it work much smother. 2. You could use Excel to arange the data you want to move to a specific cell on a specific sheet then ME would always get it's data from the same cell and sheet all the time. Then Excel could move the next data to the desired cell for next copy to OpenOffice.org. I have used this same type of movement with one of my own bank retrieval programs. Hope this may help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.