|
一口气生成106个文件,你的电脑要靠得住呀。
我将花名册放到你的样板文件中了,省得在几个工作簿之间切换。
如下请参考。
- Sub MingCe()
- Dim i As Integer, ArrNameList, List As Worksheet, Card As Worksheet, Cover As Worksheet
- Set List = Worksheets("List")
- Set Card = Worksheets("Sheet1")
- Set Cover = Worksheets("Sheet2")
- ArrNameList = List.Range("A1:E" & List.Cells(Rows.Count, 1).End(xlUp).Row)
- Application.ScreenUpdating = False
- For i = 2 To UBound(ArrNameList)
- 'For i = 2 To 5
- Card.Range("B4") = ArrNameList(i, 2)
- Card.Range("D4") = ArrNameList(i, 4)
- Card.Range("F4") = ArrNameList(i, 1)
-
- Card.Range("B13") = ArrNameList(i, 2)
- Card.Range("D13") = ArrNameList(i, 4)
- Card.Range("F13") = ArrNameList(i, 1)
-
- Cover.Range("B3") = ArrNameList(i, 2)
- Cover.Range("D3") = ArrNameList(i, 4)
- Cover.Range("F3") = ArrNameList(i, 1)
-
- Sheets(Array("Sheet1", "Sheet2")).Select
- Sheets("Sheet1").Activate
- Sheets(Array("Sheet1", "Sheet2")).Copy
- ActiveWorkbook.SaveAs ThisWorkbook.Path & "" & ArrNameList(i, 2)
- ActiveWorkbook.Close
- Next i
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|