I have been trying to solve this problem for a couple of days, but finally here.
I need to get the first row of sheet in multiple excel files, and paste into another file.
I tried read range workbook with ‘For Each’ so I can read it from multiple files, and write range into another file, but I have not got successful result yet. Can you help me here guys? Thanks in advance.