Private Sub CommandButton1_Click()
Set afile = Workbooks.Open("m:\生日.xls")
With afile.Worksheets("sheet1")
Range("A2:A" & ActiveSheet.UsedRange.Rows.Count).Copy
Worksheets("根据身份号码提起日期").Select
With afile.Sheets("sheet1")
Range("a2").Select
ActiveSheet.Paste
End With
End With
End Sub