Sub OpenWord()
Dim Wrd As Object
Set Wrd = CreateObject('word.Application')
Wrd.Visible = True
Wrd.documents.Open ('C:\\Répertoire\\Nom.doc')
End Sub
Et pour tout savoir (ou presque) sur le pilotage de Word depuis Excel, consulter en urgence la page n°3 Wiki de MichelXLD !Sub OuvrirDoc()
'Il convient d'activer la référence 'Microsoft Word XX.X Object Library'
Dim AppW As Word.Application
Dim DocW As Word.Document
Dim Chemin As String
Chemin = ThisWorkbook.Path & '\\LeFichier.doc'
Set AppW = CreateObject('Word.Application')
AppW.Visible = True
Set DocW = AppW.Documents.Open(Chemin)
End Sub
Private Sub OuvrirDoc_Click()
Dim Wrd As Object
Dim chemdoc As String
chemdoc = Worksheets('feuil1').Range('a1').Value
Set Wrd = CreateObject('word.Application')
Wrd.Visible = True
Wrd.documents.Open (chemdoc)
End Sub
Sub Open_N_Importe_Quoi()
ThisWorkbook.FollowHyperlink ActiveCell
End Sub