flightjock
New Member
- Joined
- Mar 18, 2002
- Messages
- 48
We have to use data in a worksheet from an excel file that somebody else puts in a fixed directory on our network every day. Each day this source file has another name with the date included in the name. E.g. today's file would be called DRAAF20020426.xls and tomorrow's file would be called DRAAF20020427. The older files are not deleted.
Would it be possible to use VBA to automatically select the most recent file in this source directory and open it?
Any help or suggestion or hopefully solution would be very much appreciated.
Would it be possible to use VBA to automatically select the most recent file in this source directory and open it?
Any help or suggestion or hopefully solution would be very much appreciated.