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

Hi Arthur:

Would checking the file attributes in a directory be what you want? Check
this out: http://j-walk.com/ss//excel/tips/tip97.htm

Jim

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, August 10, 2007 7:21 AM
To: Discussion of Hardware and Software issues
Subject: [dba-Tech] Determine the last file in a folder

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
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com