Loop Through a Folder of Excel Workbooks

[frankgbr]

I have been looking for a solution all day and would be grateful if someone could help me.

I have 100's of .csv workbooks in a folder "C:\ASA Japan\Database\3-Stripes\ASA output files". They are all saved in the same format with specific file names which is fine so far. What I need is a Macro which will search through this folder selecting all the data on each workbook between A1:CP2 and then copy that data (from all the sheets) into one existing work book "C:\ASA Japan\Database\3-Stripes\Database.xlsx" on sheet "Database" starting from B2:CQ2 filling in as many rows as required. The macro shouldn't search for data in Sheet1 in any of the "C:\ASA Japan\Database\3-Stripes\ASA output files", it should look for any data on any sheet located in that folder between the range A1:CP2.

I have found many macros that create new work books, but none that copy to a range on an existing work book.

Thanks in advance

[Solus Rankin]

Are they all .csv? I thought csv's' were limited to one sheet per workbook...

[Solus Rankin]

It might take a while to get through all of those files but you can try:

Please Login or Register  to view this content.

[HaHoBe]

Hi, frankgbr,

maybe have a look at CSVs to 1 Sheet. Jerry used UsedRange for the entire contents to be copied, you would need to replace that by Range("A1:CP2") to suit.

Ciao,
Holger