trying to collect data from an application and pasting it into 2 excel sheets

[aps]

HI !! I am a new comer and so hello to all. I have a problem as follows: While trying to lift data from an application and pasting it into two seperate sheets of an excel file, after about 40 to 50 successful pastes i get an error saying that the excel file is not fully loaded. i dont know why this occours and how to rectify it. The data from the application is lifed say from two notepad files, say np1 and np2. I am trying to simulate it as follows.

for count = 1 to x

activate np-1,

copy data,

activate myfile (excel file - sheet 1)

paste data

activate np-2,

copy data

activate myfile

switch to sheet 2 using the command command SEND ("^ {PGDN"})

paste data

switch to sheet 1 using the command command SEND ("^ {PGUP"})

next count

The program works ok for about 40 lifts and then bombs and i get an error saying "excel file not completely loaded or sth to that effect.

Can anybody help ?? any clues as to why i get this messege.

Thanks

aps