Sub copysh()
'另存为对话框
fileSaveName = Application.GetSaveAsFilename("表二" & Format(Now, "YYYY-MM-DD-HHmmSS") & ".xls") '以标签名+日期命名
If fileSaveName <> False Then
Sheet2.Activate
ActiveSheet.Copy
'ActiveWorkbook.SaveAs Filename:=fileSaveName & ".xls" '新表打开
ActiveWorkbook.Close SaveChanges:=True, Filename:=fileSaveName & ".xls" '新表关闭
Sheet1.Select
End If
End Sub