Combine same sheet from multiple workbooks in the same folder

Hi,

I have same format workbooks in a folder.

I would like to combine one specific sheet into one workbook. But i have to do this for multiple folders, so is it possible to do this with an vba?

I have a code that combines all OPEN workbooks, but i would like to combine all workbook in this path without opening it.

Please Login or Register  to view this content.

Give this a try:

Please Login or Register  to view this content.