|
本帖最后由 zjdh 于 2011-11-15 08:14 编辑
你的有所改进,我也想过先改名再按要求更名,就能达到每次都是从无序号文件名开始啦。
Sub Macro1()
Dim WK As Workbook, MyPath$, MyName$, NewNm$, Nm$, I%
MyPath = ThisWorkbook.Path & "\需重命名工作簿\" '请自己修改路径
MyName = Dir(MyPath & "*.xls")
Application.ScreenUpdating = False
Do While MyName <> "" '先更名
K = K + 1
Name MyPath & MyName As MyPath & "Y" & K & ".xls"
MyName = Dir
Loop
MyName = Dir(MyPath & "*.xls")
Do While MyName <> ""
Set WK = GetObject(MyPath & MyName)
NewNm = WK.Sheets(1).[b3]
NewNm2 = WK.Sheets(1).[b3]
For I = 1 To 100 '预估最大101个同名
If InStr(Nm, NewNm2) Then NewNm2 = NewNm & I
Next
Nm = Nm & "|" & NewNm2
WK.Close False
Name MyPath & MyName As MyPath & NewNm2 & ".xls"
MyName = Dir
Loop
Application.ScreenUpdating = True
MsgBox "修改完毕"
End Sub
|
|