import multiple .xlsx files into one workbook and one sheet

[icordeiro]

I have around 100 .xlsx files in one folder dated from 2013-16. These are files with the same format, that are extracted periodically from SAP and converted to .xlsx.

I want to build a database in a workbook with all these files, importing all at the same time.

All the files look like this:
Capture.PNG
Columns, formats, all equal

I want to import them into another workbook to one sheet. The ideia is that after a file is imported (values copied), it finds the last row and imports the next one, and so on until the last file.

The worksheet looks like this:
Capture2.PNG
Columns, formats, all equal to the imported files. The location of the cells is diferent (it doesn't start in A1 like the files but it will start to copy values in B10)

Any ideias on how I can achieve this?

Thanks.

[icordeiro]

This is the code i'm using currently to import just 1 file:

Please Login or Register  to view this content.