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
| Dim Vitesse(6, 1) As String
Vitesse(0, 0) = "00"
Vitesse(0, 1) = "1200 bit/s"
Vitesse(1, 0) = "01"
Vitesse(1, 1) = "2400 bit/s"
Vitesse(2, 0) = "02"
Vitesse(2, 1) = "4800 bit/s"
Vitesse(3, 0) = "03"
Vitesse(3, 1) = "9600 bit/s"
Vitesse(4, 0) = "04"
Vitesse(4, 1) = "19200 bit/s"
Vitesse(5, 0) = "05"
Vitesse(5, 1) = "38400 bit/s"
Vitesse(6, 0) = "06"
Vitesse(6, 1) = "57600 bit/s"
'Traitement sur les vitesses voie 1
If Vitesse(0, 0) = Hexa_Temp.EndsWith("00") Then Row(Idx_Row, 6) = Vitesse(0, 1)
If Vitesse(1, 0) = Hexa_Temp.EndsWith("01") Then Row(Idx_Row, 6) = Vitesse(1, 1)
If Vitesse(2, 0) = Hexa_Temp.EndsWith("02") Then Row(Idx_Row, 6) = Vitesse(2, 1)
If Vitesse(3, 0) = Hexa_Temp.EndsWith("03") Then Row(Idx_Row, 6) = Vitesse(3, 1)
If Vitesse(4, 0) = Hexa_Temp.EndsWith("04") Then Row(Idx_Row, 6) = Vitesse(4, 1)
If Vitesse(5, 0) = Hexa_Temp.EndsWith("05") Then Row(Idx_Row, 6) = Vitesse(5, 1)
If Vitesse(6, 0) = Hexa_Temp.EndsWith("06") Then Row(Idx_Row, 6) = Vitesse(6, 1)
'Traitement sur les vitesses voie 0
If Vitesse(0, 0) = Hexa_Temp2.EndsWith("00") Then Row(Idx_Row + 1, 6) = Vitesse(0, 1)
If Vitesse(1, 0) = Hexa_Temp2.EndsWith("01") Then Row(Idx_Row + 1, 6) = Vitesse(1, 1)
If Vitesse(2, 0) = Hexa_Temp2.EndsWith("02") Then Row(Idx_Row + 1, 6) = Vitesse(2, 1)
If Vitesse(3, 0) = Hexa_Temp2.EndsWith("03") Then Row(Idx_Row + 1, 6) = Vitesse(3, 1)
If Vitesse(4, 0) = Hexa_Temp2.EndsWith("04") Then Row(Idx_Row + 1, 6) = Vitesse(4, 1)
If Vitesse(5, 0) = Hexa_Temp2.EndsWith("05") Then Row(Idx_Row + 1, 6) = Vitesse(5, 1)
If Vitesse(6, 0) = Hexa_Temp2.EndsWith("06") Then Row(Idx_Row + 1, 6) = Vitesse(6, 1) |
Partager