Code to Include File name in the macro for merging data from workbooks to Worksheet

[flakedew]

The below mentioned macro merges all the data from excel files in the specific folder into the sheet named Master.
All workbooks in the folder contain data from Col. A to Col.Y.

Please Login or Register  to view this content.

The requirement is

The filename( excluding extension, .xls, .xlsx, .xlsm etc) to be included in Col.Z for each entry from the particular file.

[patel45]

if I understand well what do you want you have to add after

Please Login or Register  to view this content.

this line

Please Login or Register  to view this content.

[flakedew]

Thanks for your response..
This code is not working.
It doesnt display any filename

[patel45]

try

Please Login or Register  to view this content.