|
发表于 2016-10-20 16:58
|
显示全部楼层
本楼为最佳答案
Sub test()
Dim A, i, path, ext, oldName, newName
A = Range("a1").CurrentRegion
path = ThisWorkbook.path & "\照片文件夹\"
ext = ".jpg"
For i = 2 To UBound(A)
oldName = path & A(i, 2) & ext
newName = path & A(i, 4) & ext
If Dir(oldName) <> "" Then Name oldName As newName
Next i
End Sub |
|