I need the most recent folder on a drive

[jl39775]

I have a drive that have the following folders.

Jan02
Feb02
.
.
.
Aug02

A new folder is created manually each month i.e. in October I will create a Sep02 folder. What I need to do is grab the folder name of the last folder created. I know how to use the dir$ command but I don't know how I can tell if the folder name is the most recent one created. Does anyone have any ideas how I can do this?

Thanks,

James

[kleinma]

using the filesystemobject you can do something like

Dim FileSys As New FileSystemObject
    Dim objFolder As Folder
    Set objFolder = FileSys.GetFolder("PathHere")
    MsgBox "CREATED " & objFolder.DateCreated
    MsgBox "ACCESSED " & objFolder.DateLastAccessed
    MsgBox "MODIFIED " & objFolder.DateLastModified
    Set objFolder = Nothing
    Set FileSys = Nothing

[kidlaley]

file system object to get the files attributes or date and time

but maybe i'm wrong