I have a folder: c:\data, that contains 800 seperate .csv files
The files are too large and I cannot open them correctly. I only need the most recent 50,000 rows. Is there a way to create a macro that can access the data from the folder and extract the data I need from each unique file name like that listed above ?
I tried several macros but cannot get them to work correctly