Forum Discussion

Harry1605's avatar
Harry1605
Copper Contributor
Apr 25, 2024

Using VBA or a macro to get first row

Hello,

 

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

 

Thanks

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    I would advise not to use a macro, but Data, Get Data, From File, From Folder.

Resources