Sub test()
Cible = Range("A9").Hyperlinks(1).Address
Set WordApp = CreateObject("Word.application")
WordApp.Visible = False
WordApp.Documents.Open Filename:=Cible
WordApp.Selection.HomeKey Unit:=6
With WordApp.Selection.Find
.ClearFormatting
.Text = "Date d'application"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
WordApp.Selection.Find.Execute
WordApp.Selection.MoveRight Unit:=1, Count:=2
WordApp.Selection.MoveRight Unit:=1, Count:=10, Extend:=1
Range("D9") = WordApp.Selection
WordApp.Quit
Set WordApp = Nothing
End Sub