Transferring data IN VBA between workbooks
 

I need to transfer a range of cells for
every row one by one from one file File1.xls
to a second file File2.xls from
within a VBA program.

I had it running where it coded a cut and paste
but the program runs for 3 hours and
If I tried to do anything else where I
cut and paste I would get data from my running program
when I tried to paste.

Is there any way I can do this other than cut and paste ?

Dennis

I foud out what I was doing wrong
I had this
Range("A1") = Range("A1:P1")
which will work in a single workbook
but to a separate workbook
you have to put
Range("A1:P1") = Range("A1:P1")


"Q" wrote in message ...
I need to transfer a range of cells for
every row one by one from one file File1.xls
to a second file File2.xls from
within a VBA program.

I had it running where it coded a cut and paste
but the program runs for 3 hours and
If I tried to do anything else where I
cut and paste I would get data from my running program
when I tried to paste.

Is there any way I can do this other than cut and paste ?

Dennis