import largest csv contained within subfolders

[rseldner]

long time lurker here. I can usually find what I need from others' posts but I'm stuck this time.
I have a large set of .CSV files I'm generating within multiple subfolders (the parent folder is constant). The .CSVs are eventually deleted and replaced with new .CSVs. The total count of .CSVs can vary from time to time (usually from 10 to 50). There is always a specific .CSV of interest, and it is ALWAYS the largest .CSV in the set. However, its filename and location can change (within the subfolders contained in the parent folder). I want to be able to automatically import the largest csv.
Example directory structure where CSV6.csv would be imported:

Please Login or Register  to view this content.

I found this post and tried to play around with it but didn't have any luck:
http://www.excelforum.com/excel-prog...gest-file.html

[rseldner]

bump no response

[JBeaucaire]

This will demonstrate one way to do it. You can use the fNAME string that is stored to feed into your other macro as the import filename.

Please Login or Register  to view this content.

[rseldner]

awesome! that's working pretty darn well. I ran into a wierd issue though. If I rerun the macro after changing the CVSs a few times, the fname reference gets stuck on the previous/incorrect file. Reopening the workbook fixes the issue so it's no big deal. Thanks for the help!

[JBeaucaire]

Maybe just reset that on your way out at the end:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[rseldner]

i'll try that out. thanks again!