麻烦大家帮我看看这个VBA程序哪里有错误??解决就给分~~~~~~~

烈火焚身 烈火焚身 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
Public Sub PathName()

mPath = "D:\ScienceDirect"
If Right(mPath, 1) <> "\" Then
mPath = mPath & "\"
End If

myName = Dir(mPath, vbDirectory)
Do While myName <> ""
If myName <> "." And myName <> ".." Then
If (GetAttr(mPath & myName) And vbDirectory) = vbDirectory Then

mPath1 = mPath & myName & "\"
Debug.Print mPath & myName & "\", myName, mPath1
PathName1 (mPath1)

End If
End If
myName = Dir
Loop
End Sub


Public Sub PathName1(mPath1 As String)

myName1 = Dir(mPath1, vbDirectory)
Do While myName1 <> ""
If myName1 <> "." And myName1 <> ".." Then
If (GetAttr(mPath1 & myName1) And vbDirectory) = vbDirectory Then

Debug.Print mPath1 & myName1 & "\", myName1
mPath2 = mPath1 & myName1 & "\"

End If
End If
myName1 = Dir
Loop
End Sub
...全文

相关推荐

评论 15
收藏 已收藏
分享
返回顶部
烈火焚身
Access 7,731 成员 28,797 内容