1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
|
Private Sub Commande39_Click()
Dim xlApp As Excel.Application
Dim xlwb0, xlwb1 As Excel.Workbook
Dim xlsh0, xlsh1, xlsh2, xlsh3 As Excel.Worksheet
On Error Resume Next
Set xlApp = Nothing
Set xlwb0 = Nothing
Set xlwb1 = Nothing
Set xlsh0 = Nothing
Set xlsh1 = Nothing
Set xlsh2 = Nothing
Set xlsh3 = Nothing
On Error GoTo 0
Set xlApp = New Excel.Application
xlApp.Visible = True
Set xlwb0 = xlApp.Workbooks.Add
Set xlsh0 = xlwb0.Sheets(1)
xlwb0.Sheets.Add.Move After:=xlsh0
Set xlsh1 = xlwb0.Sheets(2)
Debug.Print xlwb0.Name & "-" & xlsh0.Name & "-" & xlsh1.Name
Set xlwb1 = xlApp.Workbooks.Add
Set xlsh2 = xlwb1.Sheets(1)
xlwb1.Sheets.Add.Move After:=xlsh2
Set xlsh3 = xlwb1.Sheets(2)
Debug.Print xlwb1.Name & "-" & xlsh2.Name & "-" & xlsh3.Name
ReDim ArrayTemp(1 To 25000, 1 To 250)
'xlwb0.xlsh0
For i = 1 To 25000
For j = 1 To 250
ArrayTemp(i, j) = 1
Next j
Next i
With xlsh0
With .Range(.Cells(1, 1), .Cells(25000, 250))
.Value = ArrayTemp
End With
End With
'xlwb0.xlsh1
For i = 1 To 25000
For j = 1 To 250
ArrayTemp(i, j) = 2
Next j
Next i
With xlsh1
With .Range(.Cells(1, 1), .Cells(25000, 250))
.Value = ArrayTemp
End With
End With
'xlwb1.xlsh2
For i = 1 To 25000
For j = 1 To 250
ArrayTemp(i, j) = 3
Next j
Next i
With xlsh2
With .Range(.Cells(1, 1), .Cells(25000, 250))
.Value = ArrayTemp
End With
End With
'xlwb1.xlsh3
For i = 1 To 25000
For j = 1 To 250
ArrayTemp(i, j) = 4
Next j
Next i
With xlsh3
With .Range(.Cells(1, 1), .Cells(25000, 250))
.Value = ArrayTemp
End With
End With
Set xlApp = Nothing
Set xlwb0 = Nothing
Set xlwb1 = Nothing
Set xlsh0 = Nothing
Set xlsh1 = Nothing
Set xlsh2 = Nothing
Set xlsh3 = Nothing
End Sub |
Partager