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

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!
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Brad" wrote:

> 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,

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


"Jerry Whittle" wrote:

> 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!
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Brad" wrote:
>
> > 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
> >