Jump to content
Macro Express Forums

Macro not behaving properly


davidgalaxy

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...