Sub test()
On Error Resume Next
Dim MonApplication As Object
Dim MonFichier As String
Set MonApplication = CreateObject("Shell.Application")
MonFichier = "\M.xlsx"
Documents("evry.docm").Activate
ActiveDocument.Tables(1).Rows(2).Cells(4).Select
Selection.range.Case = wdTitleSentence
ActiveDocument.Tables(1).Rows(2).Cells(4).Select
Selection.Copy
MonApplication.Open (MonFichier)
ActiveDocument.sheet(1).range("H1").Select
Selection.Paste
ActiveDocument.sheet(1).range("I8").Select
Selection.Copy
Documents("evry.docm").Activate
Selection.GoTo What:=wdGoToBookmark, Name:="ville2"
Selection.PasteAndFormat (wdFormatPlainText)
Set MonApplication = Nothing
End Sub