你倒是数清楚啊!我当然是按你的附件写宏啦!
工作表名称问题,修改
Sub TEST()
Workbooks.Add
ThisWorkbook.Sheets(1).Cells.Copy ActiveSheet.Range("A1")
With ActiveSheet
.Name = ThisWorkbook.Sheets(1).Name
.Shapes(1).Delete
.Buttons.Delete
End With
ThisWorkbook.Sheets(2).Cells.Copy ActiveWorkbook.Sheets(2).Range("A1")
ActiveWorkbook.Sheets(2).Name = ThisWorkbook.Sheets(2).Name
Do
fname = Application.GetSaveAsFilename(fileFilter:="Excel Files (*.xls), *.xls")
Loop Until fname <> False
ActiveWorkbook.SaveAs fname
ActiveWorkbook.Close
End Sub