Copy Files Macro

[satomma]

Hallo, i've to complete this macro but can't get out it...

Please Login or Register  to view this content.

Actually it takes all xlsx in a directory and copy the column from c till i got one, in one single file.
I would like it to let me choose the column passing the header, and create a column next to the one i copy, with the trunked file name..

Please Login or Register  to view this content.

Can anyone help me pls?

Thanks a lot

[Naveed Raza]

plz provide some example workbook then its more easy to solve ur query.