Public Sub Recherche()
Dim WbSource As Workbook, Sh As Worksheet, v As Range, TC As Range
Set WbSource = Workbooks.Open("nom réel du classeur(vbexcel)")
Set Sh = ThisWorkbook.Sheets("Index")
With WbSource
Set v = .Sheets("Data").Range("J7")
End With
With Sh
Set TC = .Range("A7")
End With
If TC.Value Like "*" & v.Value Then
'le code
Else
'reste du code
End If
End Sub