|
我有个文件夹A里面存有20个文件夹,我想做个表格目录显示A文件夹里所有的文件夹名称,只要A文件夹中新增文件夹,EXCEL目录就会自动更新
- Sub 搜索文件夹()
- Dim Arr1(), MyPath, MyName, I
- MyPath = "D:\A" '设置查找路径
- MyName = Dir(MyPath, vbDirectory) '查找目录
- Do While MyName <> ""
- If MyName <> "." And MyName <> ".." Then
- I = I + 1
- ReDim Preserve Arr1(1 To 1, 1 To I)
- Arr1(1, I) = MyName
- End If
- MyName = Dir '继续遍历寻找
- Loop
- [A2].Resize(I, 1) = Application.Transpose(Arr1) '显示在A2开始往下的单元格
- End Sub
复制代码
|
|