|
大家试试这个吧
- Option Explicit
- Sub 父子转换法()
- Dim FatherFolder(1 To 10000) As String
- Dim f, i, k, f2, f3, x
- Dim arr1(1 To 100000, 1 To 1) As String, q As Integer
- FatherFolder(1) = ThisWorkbook.Path & ""
- i = 1: k = 1
- Do While i < UBound(FatherFolder)
- If FatherFolder(i) = "" Then Exit Do
- f = Dir(FatherFolder(i), vbDirectory)
- Do
- If InStr(f, ".") = 0 And f <> "" Then
- k = k + 1
- FatherFolder(k) = FatherFolder(i) & f & ""
- End If
- f = Dir
- Loop Until f = ""
- i = i + 1
- Loop
-
- '提取各文件夹中的文件
- For x = 1 To UBound(FatherFolder)
- If FatherFolder(x) = "" Then Exit For
- f3 = Dir(FatherFolder(x) & "*.*")
- Do While f3 <> ""
- q = q + 1
- arr1(q, 1) = FatherFolder(x) & f3
- f3 = Dir
- Loop
- Next x
- ActiveSheet.UsedRange = ""
- Range("a1").Resize(q) = arr1
- End Sub
复制代码
|
|