Referencing filename to a Cell

Dear All,

The code I have below, extracts data from a closed file within a specific folder.

For every file I want to extract data, I have to edit the code within the module.

What I will like to do is to reference this part of my code to a cell say "A1".

This is where my code has

Please Login or Register  to view this content.

The below is my code:

Please Login or Register  to view this content.

Kind Regards

Laylow

Please Login or Register  to view this content.

Regards