Get Data from Closed Mutliple Workbooks

[chergian]

Hi everyone,

I have search a code that will get data from a closed workbook.

Here is the code:

Please Login or Register  to view this content.

However this code will only get the value with the specified cell.

How could i manipulate this code to loop through a given "file names", "sheets name", "data columns" according to their particular ID code.

Attach are my sample files for easy understanding.

Thanks in advance.

[AliGW]

Do not create duplicate posts. Continue in your original thread, please.