|
发表于 2016-5-18 21:10
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim MyStr$, i%
- On Error Resume Next
- MyStr = ThisWorkbook.Path & ""
- Kill MyStr & "*.*"
- arr = Range("A1").CurrentRegion
- For i = 1 To UBound(arr)
- If Len(Dir(Left(MyStr, Len(MyStr) - 3) & arr(i, 1) & ".jpg")) <> 0 Then
- FileCopy Left(MyStr, Len(MyStr) - 3) & arr(i, 1) & ".jpg", MyStr & arr(i, 1) & ".jpg"
- End If
- Next
- End Sub
复制代码 |
|