Option Explicit
Private Sub LSV_MOD_Click()
Dim numpat, Num_pages_scan, test_NumPat_SCAN, NumPat_SCAN, test_heure_scan, test_pages, test_taille, test_date_scan As String
Dim derlig, i As Long
If test_PDF_USF = "OK" Then
Unload PDF_test
test_PDF_USF = "KO"
End If
derlig = Range("A65536").End(xlUp).Row
DT_SCAN = Format(LSV_MOD.SelectedItem.ListSubItems(2).Text, "DD/MM/YYYY")
HEURE_scan = Format(LSV_MOD.SelectedItem.ListSubItems(3).Text, "HH:MM:SS")
Nb_pages = LSV_MOD.SelectedItem.ListSubItems(1).Text
Taille = LSV_MOD.SelectedItem.ListSubItems(4).Text
NomficPAT = LSV_MOD.SelectedItem
NomFicTemp = ActiveWorkbook.name
Windows(NomFicTemp).Activate
NomFeuiL = ActiveWorkbook.ActiveSheet.name
RepScan = "Z:\REC\ADM\"
For i = 1 To derlig
nomFicH = Sheets(NomFeuiL).Range("B" & i).Value
'Repfic = RepScan
numpat = Sheets(NomFeuiL).Range("A" & i).Text
test_heure_scan = Sheets(NomFeuiL).Range("D" & i).Text
test_pages = Sheets(NomFeuiL).Range("F" & i).Text
test_taille = Split(Sheets(NomFeuiL).Range("E" & i).Text, ",")(0)
'test_taille2 = Sheets(NomFeuiL).Range("E" & i).Value
test_date_scan = Sheets(NomFeuiL).Range("C" & i).Text
If numpat = NomficPAT And test_heure_scan = HEURE_scan And test_pages = Nb_pages And test_taille & "Ko" = Taille Then
PDF_test.Show 0
AppActivate (Me.Caption)
Exit For
End If
Next i
End Sub