以下代码可找出e:\tmp文件夹中最新的txt文档:
Private Sub Command1_Click()
Dim d As String, t As Date, s As String
d = Dir("e:\tmp\*.txt")
Do Until d = ""
If FileDateTime("e:\tmp\" & d) > t Then
t = FileDateTime("e:\tmp\" & d)
s = "e:\tmp\" & d
End If
d = Dir
Loop
MsgBox "最新的txt文件是" & s
End Sub