Sign in to follow this  
Followers 0
aps

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

1 post in this topic

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

Share this post


Link to post
Share on other sites



Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0