Hi,


I have a folder of 4000 .csv files containing data. For every file the data is in row 8.

I would like to create a macro that imports row 8 from all the csv files in the folder and adds them to the current worksheet.

anybody have some suggestions to how to go about this?

regards,
kbka