[dba-Tech] Determine the last file in a folder

Arthur Fuller fuller.artful at gmail.com
Fri Aug 10 09:20:32 CDT 2007


Hi all,

I'm working on some Excel VBA in which I need to determine the last file in
a folder. The folder contains one file for each business day in a month, all
named like this: 062907 (June 29). I can't necessarily trust the date stamp
on the file so I have to go by the filenames and determine the "largest"
filename, as it were.

Any suggestions?

TIA,
Arthur



More information about the dba-Tech mailing list