Dear all,

I need to retrieve a single cell value for all Excel files located in a folder called 'Customers'. For each Excel file there, the task is to capture the single value of cell Sheet1!I41.

The end output are just two columns: column 1 is the Excel file name, and column 2 is the cell value Shee1!I41.

Can you please give me a macro to accomplish this task? Thank you.