Transferring data IN VBA between workbooks

[Q]

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

[Q]

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" <[email protected]> wrote in message news:[email protected]...
> 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
>
>