Sub Click()
Dim p, f, str, t
Application.ScreenUpdating = False
Application.DisplayAlerts = False
str = ThisWorkbook.Name
p = ThisWorkbook.Path & "\"
f = Dir(p)
Do While f <> ""
If f <> str Then
With Workbooks.Open(p & f)
'1)修改工作表名
t = .Sheets(1).Name
t = VBA.Split(t, " ")(0)
.Sheets(1).Name = t
'2)修改工作簿名
t = .Name
t = Mid(t, InStr(t, "_") + 1)
t = VBA.Split(t, " ")(0)
.SaveAs p & "新建文件夹\" & t
.Close False
End With
End If
f = Dir
Loop
End Sub
基础数据.rar
(46.47 KB, 下载次数: 24)