|
Sub 遍历当层目录下的文件夹()
Dim Filename As String, mypath As String, k As Integer
mypath = ThisWorkbook.path & "\2011年报表\"
Range("A1:A10") = ""
Filename = Dir(mypath, vbDirectory)
Do
If Not Filename Like "*.*" Then
k = k + 1
Cells(k, 1) = Filename
End If
Filename = Dir
Loop Until Filename = ""
End Sub
如这段代码,用文件带不带点来区文件与文件夹,感觉不是很准确,
如一文件夹名称里带点,或文件无扩展名,文件名不带点之类的,如何区分 ?
- Sub 遍历当层目录下的文件夹()
- Dim Filename As String, mypath As String, k As Integer
- mypath = ThisWorkbook.Path & "\2011年报表"
- 'mypath = ThisWorkbook.Path & ""
- Range("A1:A10") = ""
- Filename = Dir(mypath, vbDirectory)
- Do While Len(Filename) > 0
- If Filename <> "." And Filename <> ".." Then
- If (GetAttr(mypath & "" & Filename) And vbDirectory) = 16 Then
- k = k + 1
- Cells(k, 1) = Filename
- End If
- End If
- Filename = Dir
- Loop
- End Sub
复制代码
|
|