Hello,
I have a folder: c:\data, that contains 800 seperate .csv files
i.e.
C:\ data\
a.csv
bc.csv
cf.csv
dg.csv
ez.csv
etc....
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
Bookmarks