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
| Sub Controle1()
Dim i As Integer
Dim nbTests As Byte
nbTests = Range("A1").End(xlDown).Row * (1 / 100)
Application.ScreenUpdating = False
Print #1,
Print #1, "Contrôle N°1"
Print #1,
' PREMIER TEST
Print #1,
Print #1, "Test 1"
Print #1,
Columns("A:AD").Select
Selection.Sort Key1:=Range("Z2"), Order1:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
For i = 2 To nbTests + 1
Print #1, Left(Range("A" & i).Text, 10) & Space(10 - Len(Left(Range("A" & i).Text, 10))) & Left(Range("B" & i).Text, 4) & Space(4 - Len(Left(Range("B" & i).Text, 4))) & Left(Range("C" & i).Text, 30) & Space(30 - Len(Left(Range("C" & i).Text, 30))) & _
Left(Range("D" & i).Text, 9) & Space(9 - Len(Left(Range("D" & i).Text, 9))) & Left(Range("E" & i).Text, 13) & Space(13 - Len(Left(Range("E" & i).Text, 13))) & Left(Range("F" & i).Text, 14) & Space(14 - Len(Left(Range("F" & i).Text, 14))) & _
Left(Range("G" & i).Text, 4) & Space(4 - Len(Left(Range("G" & i).Text, 4))) & Left(Range("H" & i).Text, 1) & Space(1 - Len(Left(Range("H" & i).Text, 1))) & Left(Range("I" & i).Text, 1) & Space(1 - Len(Left(Range("I" & i).Text, 1))) & _
Left(Range("J" & i).Text, 1) & Space(1 - Len(Left(Range("J" & i).Text, 1))) & Left(Range("K" & i).Text, 1) & Space(1 - Len(Left(Range("K" & i).Text, 1))) & Left(Range("L" & i).Text, 4) & Space(4 - Len(Left(Range("L" & i).Text, 4))) & _
Left(Range("M" & i).Text, 10) & Space(10 - Len(Left(Range("M" & i).Text, 10))) & Left(Range("N" & i).Text, 13) & Space(13 - Len(Left(Range("N" & i).Text, 13))) & Left(Range("O" & i).Text, 2) & Space(2 - Len(Left(Range("O" & i).Text, 2))) & _
Left(Range("P" & i).Text, 30) & Space(30 - Len(Left(Range("P" & i).Text, 30))) & Left(Range("Q" & i).Text, 30) & Space(30 - Len(Left(Range("Q" & i).Text, 30))) & Left(Range("R" & i).Text, 5) & Space(5 - Len(Left(Range("R" & i).Text, 5))) & _
Left(Range("S" & i).Text, 7) & Space(7 - Len(Left(Range("S" & i).Text, 7))) & Left(Range("T" & i).Text, 14) & Space(14 - Len(Left(Range("T" & i).Text, 14))) & Left(Range("U" & i).Text, 14) & Space(14 - Len(Left(Range("U" & i).Text, 14))) & _
Left(Range("V" & i).Text, 7) & Space(7 - Len(Left(Range("V" & i).Text, 7))) & Left(Range("W" & i).Text, 14) & Space(14 - Len(Left(Range("W" & i).Text, 14))) & Left(Range("X" & i).Text, 1) & Space(1 - Len(Left(Range("X" & i).Text, 1))) & _
Left(Range("Y" & i).Text, 14) & Space(14 - Len(Left(Range("Y" & i).Text, 14))) & Left(Range("Z" & i).Text, 14) & Space(14 - Len(Left(Range("Z" & i).Text, 14))) & Left(Range("AA" & i).Text, 1) & Space(1 - Len(Left(Range("AA" & i).Text, 1))) & _
Left(Range("AB" & i).Text, 10) & Space(10 - Len(Left(Range("AB" & i).Text, 10))) & Left(Range("AC" & i).Text, 1) & Space(1 - Len(Left(Range("AC" & i).Text, 1))) & Left(Range("AD" & i).Text, 10) & Space(10 - Len(Left(Range("AD" & i).Text, 10)))
Next i
Application.ScreenUpdating = True
End Sub |
Partager