Sub Macro2() Application.DisplayAlerts = False Workbooks.Open ThisWorkbook.Path & "\调用数据.xls" For Each sh In Worksheets If sh.Name = "目录" Then sh.Delete Workbooks("调用数据.xls").Save Workbooks("调用数据.xls").Close Exit For End If Next Application.DisplayAlerts = True End Sub |