Private Sub CommandButton1_Click()
Application.EnableEvents = False
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Sheets("涵洞").Select
x = 429
Sheets("涵洞").Select
Sheets("模板").Range("E7").Value = Sheets("涵洞").Cells(x, "L").Value
Sheets("模板").Range("M7").Value = Sheets("涵洞").Cells(x, "I").Value
Sheets("模板").Range("U7").Value = Sheets("涵洞").Cells(x, "K").Value
Sheets("模板").Range("E8").Value = Sheets("涵洞").Cells(x, "N").Value
Sheets("模板").Range("M8").Value = Sheets("涵洞").Cells(x, "O").Value
Sheets("模板").Range("U9").Value = Sheets("涵洞").Cells(x, "P").Value
Sheets("模板").Range("E4").Value = Sheets("涵洞").Cells(x, "C").Value
Sheets("模板").Range("U4").Value = Sheets("涵洞").Cells(x, "F").Value
M = Sheets("涵洞").Cells(x, "B").Value
Z = Sheets("涵洞").Cells(x, "C").Value
Sheets("模板").Select
' Sheets("模板").PrintOut
Sheets("模板").Copy
' ChDir ThisWorkbook.Path & "\明白卡"
wn = M & Z & ".xlsm"
' Debug.Print "文件名:", wn
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & wn, FileFormat:=xlExcel8
Windows(wn).Close True
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True
End Sub