舒云天 发表于 2016-5-5 19:35
出现错误如截图
Sub moveFiles()
Dim fso, A, i%, p$, desP$, desF$, msg$
Set fso = CreateObject("Scripting.FileSystemObject")
p = ThisWorkbook.Path & "\"
A = Sheets(1).Range("a1").CurrentRegion
For i = 1 To UBound(A)
desF = p & A(i, 1) & ".doc"
desP = p & A(i, 2) & "\"
If fso.FolderExists(desP) = False Then fso.CreateFolder (desP)
If fso.FileExists(desF) = False Then msg = msg & "," & A(i, 1) Else fso.moveFile desF, desP
Next i
MsgBox Mid(msg, 2), , "无效文件清单"
End Sub
3.rar
(40.2 KB, 下载次数: 10)