|
发表于 2013-9-20 14:37
|
显示全部楼层
本楼为最佳答案
- Sub CopyFiles()
- Dim strPath$, DstPath$
- Dim strFilename$, strTemp$
- Dim i&, j&
- Dim arr
- On Error Resume Next
-
- strPath = ThisWorkbook.Path & Application.PathSeparator
- DstPath = strPath & "结果" & Application.PathSeparator
- arr = Range("a5").CurrentRegion
- For i = LBound(arr) + 1 To UBound(arr)
- strTemp = Replace(arr(i, 1), " ", "") & ".doc"
- If Len(strTemp) > 4 Then
- For j = LBound(arr, 2) + 1 To UBound(arr, 2)
- If Len(arr(i, j)) Then
- MkDir (DstPath & arr(i, j))
- FileCopy strPath & strTemp, DstPath & arr(i, j) & Application.PathSeparator & strTemp
- End If
- Next
- End If
- Next
- MsgBox "复制完成"
-
- End Sub
复制代码 |
|