Sub yy()
Dim twb, wb
Dim ws As Worksheet
Application.ScreenUpdating = False
Application.DisplayAlerts = False
'mys = InputBox("请输入需要更改的名称。")
'm = "检测报告"
Set Nm = ThisWorkbook
With Application.FileSearch 这句代码是黄色提示
.LookIn = Nm.path
.Filename = "*.xls"
.Execute msoSortByFileName
For Each s In .FoundFiles
If s <> Nm.FullName Then
Set wb = Workbooks.Open(s)
wb.Close True
End If
Next s
End With
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub