|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
上面的Call searfile(fp, ".xlsx") 改为
Call searfile(fp, ".xls")
下面一个改为:
Sub searfile(fp As String, fkey As String)
Dim Arr1() As String, i1 As Integer, i2 As Integer, fm
If Right(fp, 1) <> "\" Then fp = fp & "\"
If Len(fkey) < 1 Then fkey = ".xls" '文件类型省略则仅搜索.xls文件
fm = Dir(fp, vbDirectory)
Do While fm <> ""
If fm <> "." And fm <> ".." Then
If (GetAttr(fp & fm) And vbDirectory) = vbDirectory Then
i1 = i1 + 1
ReDim Preserve Arr1(1 To i1)
Arr1(i1) = fp & fm
End If
If Right(fm, Len(fkey)) = fkey Then
r = r + 1
ReDim Preserve Brr(1 To 2, 1 To r)
Brr(1, r) = fp
Brr(2, r) = fm
End If
End If
fm = Dir
Loop
For i2 = 1 To i1
Call searfile(Arr1(i2), fkey)
Next
End Sub
|
|