Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Controlling Linked Data to Workbooks | Excel Worksheet Functions |