麻烦大家帮我看看这个VBA程序哪里有错误??解决就给分~~~~~~~
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
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
...全文
相关推荐
CAD-vba开发中VBA“找不到工程或库”错误解决方法
CAD-vba开发中VBA“找不到工程或库”错误解决方法,解决vba开发中的难题
VBA常见错误原因分析
本文将详细介绍VBA常见错误的原因和解决方法,帮助读者更好地学习和应用Excel VBA。编译错误编译错误是指在编译程序时出现的错误。
VBA程序解释器
**错误处理(Error Handling)**:通过On Error语句,程序员可以设置错误处理机制,当程序出错时,可以捕获错误并执行相应的错误处理代码,提高程序的健壮性。9.
vba错误代码.pdf
VBA 错误代码详解VBA 错误代码是一种通用的错误处理机制,旨在帮助开发者捕获和处理程序中的错误。VBA 错误代码共有三种类型:可捕获的错误、不可捕获的错误和系统错误。
word vba编程时出现“无效调用ME关键字”的解决方法
按照上述解决方案,通常可以解决Word VBA编程中“无效调用ME关键字”的问题,使VBA项目能够恢复正常运行。然而,防止类似问题的产生更应依赖于良好的代码结构和清晰的项目设计。


