Copy same range in many excel files and paste into a main file

**dualaudio454252** · 11-14-2014, 06:02 PM

Please, I need a little help.
I want to copy a range from many excel files and paste into another one.

All the files (with the ranges to be copied) are closed inside a folder, with sequential names .
The file that will receive the ranges ("Boxx") is in another folder.

I want to copy the range "B1:S5" and paste in "B1"(in "Boxx").
Then, the next ranges should be pasted sequentially in B6, B11, B16, etc.

The closest VBA code I've found and modified is here:

Please Login or Register  to view this content.

What's the missed line??

**mikeTRON** · 11-14-2014, 08:23 PM

I modified some code I already had for something similar.

Please Login or Register  to view this content.

**dualaudio454252** · 11-14-2014, 09:08 PM

All right, I should have searched inside this forum, but untill now Google kept saying me that there was nothing that could help me anywhere in the web.

I've read the links bellow:
http://www.excelforum.com/excel-prog...ster-file.html
http://www.mrexcel.com/forum/excel-q...ed-folder.html

That gave the code I've modified now, but I just want to copy and paste like values, so I've glued this:
.PasteSpecial xlPasteValues
But it's not working.
Must say that I'm learning VBA from scratch.
One last help, please:

Please Login or Register  to view this content.

**dualaudio454252** · 11-14-2014, 09:31 PM

mikeTRON, sorry, I was writing the upper message while you were writing, too.
Like I said, that code is almost complete.
I just need to know where to put that ".PasteSpecial xlPasteValues" or so.
I've tried to use your code, but the other has some advantages.
Thank you very, very much for your effort, but can you help with that?

**dualaudio454252** · 11-15-2014, 05:25 PM

This way it's working for me:

Please Login or Register  to view this content.

Thank you so, so much mikeTRON, you were the only who tried to help me!

Copy same range in many excel files and paste into a main file

LinkBack

Thread Tools

Rate This Thread

Display

Copy same range in many excel files and paste into a main file

Re: Copy same range in many excel files and paste into a main file

Re: Copy same range in many excel files and paste into a main file

Re: Copy same range in many excel files and paste into a main file

Re: Copy same range in many excel files and paste into a main file

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy/paste Range of worksheets of several files in a folder to a master file

5 files open 10 sheets each need macro to copy and paste ranges from 4 files into 5th file

Code to copy, paste data of sheet 1 of several files in a folder to a main summary sheet

Merging multiple Excel files into tabs of one excel file without having to copy and paste?

Copy-Paste Macro of 3 columns from multiple excel files into one summary file

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions