How can we Link to the Most Current .txt file in a folder

[Brad]

We have an existing system that creates a small transaction file (flat file)
daily with a date stamp in the file name. All of these files are stored in
one folder, one file per day.

We would like to read the contents of the newest version of this file via
Access 2007. We know how to link to a specific flat file with Access 2007.
What we cannot figure out is how to programmatically determine (in VBA) which
file is the “most currentâ€. Is this possible?

Thanks

Brad_55

 

[Jerry Whittle]

In the same situation, I found it better to not attempt to hit a moving
target. In other words, have the other system create the file with the same
name every day. If you need to keep a copy of it, maybe the other system
could create two files daily: one 'plain' and the other with the date
timestamp.

A dozen donuts for the developers on the other system should do the trick!

 

[Brad]

Jerry,

Thanks for the great idea!

We had not thought of this approach, but it seems like a really good one.

I am now off to the local donut shop

Brad