Jump to content
Macro Express Forums

davidgalaxy

Members
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

 Content Type 

Posts posted by davidgalaxy

  1. Macro not behaving properly

    in Macro Express 3.x

    Posted

    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!!

  2. Macro not behaving properly

    in Macro Express and Macro Express Pro

    Posted

    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!!

×
×
  • Create New...