Copy specific range from several workbooks with 2 sheets each located in same folder

First: I'm a newbie in vb.
I've been trying to combine different codes in the forum to get what I want but with no luck.
Every day I get 4-5 excel-files in a folder, the workbooks has different names every day. From each workbook I want to copy range A6:C50 from every sheet. Each workbook contains 2 sheets with various names.
I want to paste it in the open workbook in the first empty row. This workbook should also contain the macro.
The problem is that I want everything I copy from the first sheet in every workbook to be pasted into columns A:C, and from the second sheet into columns F:H. The data from the second sheet could also be pasted into another sheet. I can manage this later with another code.
I prefer to do this with the workbooks closed. (the workbooks I copy from)

It's not always there is data in every row, so if it's possible to only copy the rows that contains a value in column A, it would be great.
Greatful for all the help I can get since I'm not very good with vb.
/rog

Edit the fPath string in this macro, then give it a try.

Please Login or Register  to view this content.

Thank you very much for your time.
This code worked fine, I just had to add one thing.
When a sheet was blank the code stopped, so I just put in an error line.
See underline below

This code is saving me hours of work. I can use it for the daily reports, and modify it so I can sum up all the reports to a monthly report.
Thanks again.


/rog

Please Login or Register  to view this content.

[/QUOTE]