Import data from multiple xls-files

[matthijsm]

Hello to all!

I got the following problem:

I need to import data from a specific sheet from multiple excel files in one folder.

For example:

There is a folder with xls files. Me and my co-workers use the xls file to keep track of our phone records. I would like to make a summary of all the files. Therefore I use a master xls (located in another folder).

To make the summary it's necessary to copy some data from all the single Excel files to the master.xls

In this example the data needed to be copied is located on sheet 6 A72:G80

I could use the paste special option in Excel, but that's a lot of work and the filenames may not change.

I think it's possible and much easier to this with VBA, but I don't now how. Can you help me out?

 

[Andrew Poulsom]

Look here:

http://www.rondebruin.nl/copy3.htm

 

[matthijsm]

Thank you, I will give it a try!

 

[matthijsm]

This is a very nice code, just what I was looking for. Only one, problem. This code creates a new workbook with a new sheet.

I want to import the data to a workbook that already exists, for example copy it to the sheet where the code is in, on sheet "Data".

How can I achieve that?

 

[matthijsm]

I found a workaround!