Using VBA or a macro to get first row

Copper Contributor



I have a number of xlsx files in a folder and want to take the first (header) row from each of the files and place them in a new file.


How can I do this



1 Reply
I would advise not to use a macro, but Data, Get Data, From File, From Folder.