Transferring data IN VBA between workbooks

  • Thread starter Thread starter Q
  • Start date Start date
Q

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
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting Files 3
HeapSort VBA function 1
Merging 800 Excel files 1
how to keep formula don't changed when I copy the file the folder 1
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
How to transfer the data from userform to spreadsheet for specific dates 0
combining data from several excel files into one file 3
Excel VBA coding problem 2

Back
Top