Bonjour,
voici un exemple,
Sub Ouvrir_Fichier()
Dim fn As Variant
ChDir "C:\Users\xxxxx\Documents" 'à adapter
fn = Application.GetOpenFilename("All files,*.*,Excel-files,*.xls,Word Files,*.doc,PDF Files,*.pdf,", 1, "", , False)
If TypeName(fn) = "Boolean" Then Exit Sub 'si aucun fichier choisi
Debug.Print "Selected file: " & fn 'test
extention = Right(fn, 4)
Select Case True
Case extention Like "*pdf": ActiveWorkbook.FollowHyperlink Address:=fn
Case extention Like "*xls*": Workbooks.Open fn
Case extention Like "*doc*": Call GetWord(CStr(fn))
Case Else: Exit Sub
End Select
End Sub
Sub GetWord(fichier)
'nécessite d'activer la référence à Microsoft Word xx Object Library
Dim objWord
Dim objDoc
Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Documents.Open(fichier)
objWord.Visible = True
objWord.Activate
End Sub