append file name to all rows in last column for each of imported rows

[gutterball]

Hello all,

I am using some code to bring in all of the data from multiple spread sheets in a folder.

I do not know how to change the code to append the file name of the imported workbooks to the last column of the imported rows.

Can anyone point me in the right direction?

Please Login or Register  to view this content.

Thanks.

[Parth007]

The Below code will plot Filename to last column of each row..
not sure how to club it.. just give a try

Please Login or Register  to view this content.