Loop workbooks – collect data from each

[zealot]

Hi,
I wonder if it is possible to loop through all the workbook files in a directory and save - one after another - the contents of the sheet1 tab from each of these workbooks (range A1:C10) in a single master file?
Can you help me with this code please?
Dava

[KOKOSEK]

From internet (with small modifications):

Please Login or Register  to view this content.

[davesexcel]

Here's a thread on that

https://www.excelforum.com/excel-pro...te-folder.html

[zealot]

fantastic - thnaks - let me try!

[zealot]

for somereason thsi macro spkips some of the files - does nto copy the contents - what mitgh cause this? it copied like 20% of all data....I added a one second delay to the end of loop and still it does nto copy all

[davesexcel]

for somereason thsi macro spkips some of the files - does nto copy the contents - what mitgh cause this? it copied like 20% of all data....I added a one second delay to the end of loop and still it does nto copy all

Who are you talking to?

Show the code you are using as well.