在excel中以A列中的文字命名的图片，怎样批量修改成以B列中名字

Question

用VBA的时候路径怎么弄？

Answer 1

如果会VBA，运行一下Rename即可
Sub Rename()
On Error Resume Next
If MsgBox("是否改名？", 48) = vbNo Then Exit Sub
Sheet1.Select
Range("A1").Select
For r = 1 To Range(Selection, Selection.End(xlDown)).Rows.Count
Name ThisWorkbook.Path & "\" & Range("A" & r).Value As ThisWorkbook.Path & "\" & Range("B" & r).Value
Next
End Sub

Answer 2

a列前插一列,填充ren 然后A与B前个再查一列写入实际路径
最后复制下来保存为一个BAT文件运行!