|
- Sub test()
- Dim arr, str_Path$, k%, i%, str_Name$
- arr = Sheet2.Range("a1").CurrentRegion
- str_Path = ThisWorkbook.Path & "\"
- Application.ScreenUpdating = False
- For k = 2 To UBound(arr)
- For i = 1 To arr(k, 2)
- Sheet1.Copy
- str_Name = str_Path & arr(k, 1) & "\" & arr(k, 1) & "_" & i & ".xlsx"
- ActiveWorkbook.SaveAs str_Name
- ActiveWorkbook.Close False
- Next i
- Next k
- Application.ScreenUpdating = True
- End Sub
复制代码
这前面的序号和复制代码是怎么发出来的?????
|
|