Loop trough all folders and subfolders and copy data

**forfiett** · 06-17-2013, 01:31 PM

Good day to everyone,

I furthermore need your help with making code that will copy data from cell A3 (sheet table) from all excel workbooks in folders and suborders. In all folders are same workbook with different names and values in A3 so i need to do a statistic of all of them. I think the better option is to loop trough all and copy vale from A3 to the last empty row of main workbook on sheet TOTAL.

Has anyone any idea how to do that?

Your help will be much appreciated,

brgds,
forfiett

**tehneXus** · 06-17-2013, 03:20 PM

Hi,

please check this example: GetFromFiles.xlsm

You'll have to adapt the main path, name of the target worksheet and name of the sheet in the workbooks to take data from. If the source sheet name is not the same a window will pop up asking you which sheet to take. This one goes without opening the workbooks, if the sheet names are different in each of the files and you do not want to select the sheet each time you'll have to open them.

Contains:

Please Login or Register  to view this content.

**forfiett** · 06-18-2013, 04:23 PM

Good day,

first of all many thanks for provided code.

My next question is wahte should I do if I want to copy content from A3 to colum A, B6 to colum B, E25 to column C and R21 to column D?

and also why I get these error:

error.JPG