织梦CMS - 轻松建站从此开始!

VBA教程、excel VBA编程、VBA视频、VBA控件,VBA应用教程,vba技巧

vba實戰-VBA文件夹操作-遍历子文件夹

时间:2009-02-04 08:15来源:未知 作者:tang 点击:
Private Sub Command1_Click() Listfiles d:\JAVA, List1 End Sub Sub Listfiles(ByVal mydir As String, ByVal filelist As ListBox) Dim i As Long, dirlevel As Long, fname As String, dirlist() As String mydir = IIf(Right(mydir, 1) = \, mydir, mydir \) fname
Private Sub Command1_Click()
Listfiles "d:\JAVA", List1
End Sub
Sub Listfiles(ByVal mydir As String, ByVal filelist As ListBox)
Dim i As Long, dirlevel As Long, fname As String, dirlist() As String
mydir = IIf(Right(mydir, 1) = "\", mydir, mydir & "\")
fname = Dir(mydir)
Do While fname <> ""
filelist.AddItem mydir & fname
fname = Dir
Loop
fname = LCase(Dir(mydir, vbDirectory))
Do While fname <> ""
If fname <> "." And fname <> ".." Then
If GetAttr(mydir & fname) And vbDirectory Then
dirlevel = dirlevel + 1
ReDim Preserve dirlist(dirlevel)
dirlist(dirlevel) = mydir & fname
End If
End If
fname = Dir
DoEvents
Loop
For i = 1 To dirlevel
Listfiles dirlist(i) & "\", filelist
Next
End Sub

(责任编辑:admin)
顶一下
(0)
0%
踩一下
(1)
100%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
验证码: 点击我更换图片