|
- <P>Sub 按钮1_Click()
- Dim arr(), p$, f$, i%
- Dim fso As Object</P>
- <P> arr = [{"xls",0;"doc",0;"txt",0}]
- p = ThisWorkbook.Path & ""
- Set fso = CreateObject("Scripting.FileSystemObject")</P>
- <P> f = Dir(p)
- Do While f <> ""
- For i = 1 To UBound(arr)
- If fso.GetExtensionName(p & f) = arr(i, 1) Then
- arr(i, 2) = arr(i, 2) + 1
- Exit For
- End If
- Next i
- f = Dir
- Loop</P>
- <P> For i = 1 To UBound(arr)
- MsgBox arr(i, 1) & "文档个数:" & arr(i, 2) & "个"
- Next i
- End Sub</P>
复制代码
1.rar
(19.73 KB, 下载次数: 8)
|
|