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
| Public xlMyApp As Excel.Application
Public xlMyBooks As Excel.Workbooks
Public xlMyBook As Excel.Workbook
Type Resultats
Lignes As Long
Adresse As String
Valeur As Variant
End Type
Function RechercheExcel( _
Chemin As String, _
Fichier As String, _
Feuille As String, _
MotRecherche As String) As Variant
Application.Volatile
Dim Cible As String, PlagedeRecherche As String
Dim CelluleTrouve As Range
Feuille = Feuille & "$"
PlagedeRecherche = "A:A" & Range("A1").End(xlDown).Row
With Range(PlagedeRecherche)
Set CelluleTrouve = .Find(What:=Cellule.Value, LookIn:=MotRecherche)
End With
If Not (CelluleTrouve Is Nothing) Then
VarBte.Ligne = CelluleTrouve.Row
VarBte.Adresse = CelluleTrouve.Address
Else
VarBte.Ligne = 0
End If
Set CelluleTrouve = Nothing
If xlMyApp Is Nothing Then
Set Source = CreateObject("Excel.Application")
Set xlMyBooks = xlMyApp.Workbooks
xlMyApp.Visible = True
End If
End Function |
Partager