Sub saveit()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Sheets(1).Copy
ActiveSheet.DrawingObjects.Delete '会删除 表单控件 ActiveX控件
Call delCode(ActiveWorkbook)
ActiveWorkbook.SaveAs Filename:="C:\Users\Administrator\Desktop\" & Format(Date, "yyyymmdd汇总")
ActiveWorkbook.Close
End Sub
'删除模块
Sub delCode(wb)
Dim c
For Each c In wb.VBProject.VBComponents
If c.Type = 100 Then
c.CodeModule.DeleteLines 1, c.CodeModule.CountOfLines
Else
wb.VBProject.VBComponents.Remove c
End If
Next
End Sub