|
- Sub Test()
-
- Dim strMaxDateTime As String
- Dim strFileName As String
- Dim lngIndex As Long
-
- Dim strFileNames(1 To 10, 1 To 2) As String 'strFileNames(X,1) 时间,strFileNames(X,2)文件名
-
- '假设你用FileDateTime 处理了文件,并将文件名和时间存入了 strFileNames 数组
-
- For lngIndex = LBound(strFileNames) To UBound(strFileNames)
- If strMaxDateTime = "" Then
- strMaxDateTime = strFileNames(lngIndex, 1)
- strFileName = strFileNames(lngIndex, 2)
- ElseIf CDate(strMaxDateTime) < CDate(strFileNames(lngIndex, 1)) Then
- strMaxDateTime = strFileNames(lngIndex, 1)
- strFileName = strFileNames(lngIndex, 2)
- End If
- Next
-
- MsgBox "最新的文件名是:" & strFileName & ", 创建时间为: " & strMaxDateTime
- End Sub
复制代码 |
|