|
发表于 2017-7-10 16:49
|
显示全部楼层
本楼为最佳答案
- Sub 生成()
- Application.DisplayAlerts = False
- Dim brr(1 To 49), L, wb As Workbook
- For i = 1 To 49: brr(i) = i: Next
- hs = [a1] '行数
- For k = 1 To 5 '生成工作簿个数
- ReDim arr(1 To hs, 1 To 7)
- For i = 1 To hs
- crr = brr: L = 49
- For j = 1 To 7
- p = Int(Rnd * L + 1)
- arr(i, j) = crr(p)
- crr(p) = crr(L)
- L = L - 1
- Next
- Next
- Set wb = Workbooks.Add
- wb.Sheets(1).[a1].Resize(hs, 7) = arr
- wb.SaveAs ThisWorkbook.Path & "" & k & ".xlsx"
- wb.Close True
- Next
- Application.DisplayAlerts = True
- End Sub
复制代码 |
|