Open 132 files and copy data into master file

[Geordie]

Hi All

I would like to open 132 files with different names from 1 to 132 and then copy data from each file and paste into a new master file

please point me in the right direction

Many thanks

[arlu1201]

In what format are these files? .xlsx or .xls or .csv?

Are all these files stored in one folder?

Is it only one sheet that needs to be copied from each of these files?

[alansidman]

Here is one solution:

http://chandoo.org/wp/2012/04/09/con...cel-files-vba/

and a second solution:

http://stackoverflow.com/questions/1...her-results-fi

[Geordie]

Hi

Thanks for the quick responses

Yes all of the files are in one location and i only really need to copy about three rows from each file

so on the master file i have two sheets and the rows from the first file are pasted into Sheet2 of the master file, then the next set of rows pasted in in the next row down and so on until all 132 files are been done.

i hope this helps


i have looked at the links and i dont understand the code - sorry

[arlu1201]

Also what format are the files in? If you are using excel 2007 or 2010, please update the same in your profile so its easier to help you.

[arlu1201]

Try this code considering your format is .xlsx. Change the path in the code to match your system path where the files are stored -

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button