Incrementally copying from Excel to another program

[demirtas1]

Continuing the discussion from How to incrementally copy and paste cells from Excel?:

@demirtas1

Hi

I have been trying to do this for quite some time but i can't seem to find how to do....

I intent to incrementally copy and paste cells from Microsoft Excel to another application.

All the cells that I require start at A1 and go down to A4300. I would like to copy 50 cells of A at a time.

e.g.

Copy A1 to A50 then open the other app and paste, then come back
copy A51 to A100 then .........
copyA101-A150 then.... repeat until all the active cells are completed or i reach cell A4300.

I just need help with the part of incrementally copying in Excel.

Can anyone suggest any ideas? provide a basic applescript?
I have created a script to click shift down and copy x50 times then paste on the other application. But the problem is that when i come back to Excel and click down the selection does not start at Cell A51 it starts at Cell A2 and as a result copies 50 cells from A2 which had already been copied in the first attempt starting at A1.

Many thanks.

[Jack_Brannen]

@demirtas1 What is the end goal? A regex find-change might get you there faster.