download files in folder

Hi,

is there a way i can download all the data in columns C & D from every file which is in a specific folder??

thanks

http://www.ozgrid.com/VBA/loop-through.htm

Hi,

it doesn't quite do what i need it to, as i need it to opena and then copy the information from row c and d into another file....however it needs to do this for around 30 sheets and cannot overwrite the information pasted from another sheet

You have 2 steps as I see it.
1. Open each workbook.
2. Copy and paste data.

The link I gave, showed how to interate and get and open the workbooks. Your work then would start by adding step 2.

I am worried about step 2 though. If you have 30 sheets in each workbook and expect to add that data to a master workbook, I fear that you may exceed the number of rows.

In any case, to help you do it, I would need to know what sheets you expect to copy and how to handle missing data. Would the case be that if Cx="" then stop or if Cx:Dx ="" then stop, where x=a row number.

If I posted code to do it for one sheet, could you handle it from there?