Option Explicit Dim WjFileys As FileSystemObjectPrivate Sub Command1_Click() Dim FileStr As String Dim FileObj As File, FileTmp As File Dim ThisFile As String FileStr = Dir("c:\*.*") Set FileTmp = WjFileSys.GetFile(FileStr) Do While FileStr <> "" Set FileObj = WjFileSys.GetFile(FileStr) If FileObj.DateLastModified > FileTmp.DateLastModified Then ThisFile = FileObj.Name End If FileStr = Dir Loop MsgBox "最新的文件为:" & ThisFile End SubPrivate Sub Form_Load() Set WjFileSys = CreateObject("Scripting.FileSystemObject") End Sub
Dim WjFileys As FileSystemObjectPrivate Sub Command1_Click()
Dim FileStr As String
Dim FileObj As File, FileTmp As File
Dim ThisFile As String
FileStr = Dir("c:\*.*")
Set FileTmp = WjFileSys.GetFile(FileStr)
Do While FileStr <> ""
Set FileObj = WjFileSys.GetFile(FileStr)
If FileObj.DateLastModified > FileTmp.DateLastModified Then
ThisFile = FileObj.Name
End If
FileStr = Dir
Loop
MsgBox "最新的文件为:" & ThisFile
End SubPrivate Sub Form_Load()
Set WjFileSys = CreateObject("Scripting.FileSystemObject")
End Sub
msg=UCase(filespec)&vbCrLf
msg=msg&f.DateCreated&vbCrLf
for each item in objfolder这样就得到了其中的每一个文件