Importing most current csv file within a folder

[joflow21]

I need to figure out how to write a code that will import the most current csv file within a specified folder. What I have now is...

DoCmd.TransferText acImportDelim, "1", "LFGLoanRpt", "J:\Processing\Documentation\Reporting\LNL\MarksLoanReport\MarksLoanReport_01-03-2014.csv", False, "", 437

Every business day, a new file is added. How do I have it import the most current file?

Thanks,
Joflow

[rpeare]

you'll probably have to find the most recent file by one of two methods

1. if your file names are always the same format you can take the previous day's date (or the current days' date) and look for a file with that name
or
2. use filesystemobject commands to cycle through files in a folder and find the most recent one by datemodified or datecreated

I prefer the latter

here's a link to an example of cycling through files in a specific folder:

http://blogs.technet.com/b/heyscript...ubfolders.aspx

here's a list of the properties you can access with the filesystemobject commands:

http://msdn.microsoft.com/en-us/libr...=vs.84%29.aspx

you most likely want one of these

DateCreated
DateLastAccessed
DateLastModified

you can cycle through the files using a simple date check to find the most recent then once you've processed all the files use the file with the most recent relevant date

[joflow21]

Thank you rpeare. I apologize for taking so long to respond. It has been a rough year so far.