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

Perfect. Thanks a bunch.

Arthur

On 8/10/07, Jim Lawrence <accessd at shaw.ca> wrote:
>
> 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
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>