|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
根据你的附件
Private Sub CommandButton3_Click()
'引用 Microsoft Scripting Runtime
' Dim Fso As New FileSystemObject
Set Fso = CreateObject("Scripting.FileSystemObject")
Dim Pat_H, Curfiles, Mf, Mfs(1 To 1000, 1 To 2)
Pat_H = ThisWorkbook.Path & "\" 'Application.GetOpenFilename("请选择一个目录 (*.jpg), *.jpg", , "请选择一个文件以确定目录")
Set Curfiles = Fso.GetFolder(Pat_H).Files
i = 1
For Each Mf In Curfiles
If UCase(Mf.Name) Like "*.JPG" Then
Mfs(i, 1) = Left(Mf.Name, Len(Mf.Name) - 4)
Mfs(i, 2) = Mf.DateLastModified
i = i + 1
End If
Next
[A2].Resize(i - 1, 2) = Mfs
End Sub |
|