Sub test()
PT = InputBox("请输入新文件名称", "文件名设置")
If PT = "" Then PT = "工资" & Format(Date, "YYYYMMDD")
FL = ThisWorkbook.Path & "\太阳\" & PT & ".XLS"
ActiveSheet.Copy
With ActiveWorkbook
For Each ms In .Sheets(1).Shapes
If ms.Type = 8 Then ms.Delete
Next ms
.SaveAs FL
.Close
End With
End Sub