Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Private Sub PrintFichier(sNomFichier As String)
Dim Rep As Integer
Dim hwnd As Long
Rep = ShellExecute(hwnd, "Print", sNomFichier, 0&, 0&, 1)
DoEvents
End Sub
Sub Tst()
Dim sDossier As String
Dim sFichier As String
Dim Nomfichier As Variant
Nomfichier = ActiveCell.Hyperlinks(1).Address
If Left(Nomfichier, 2) = "FM" Then
Nomfichier = ActiveWorkbook.Path & "\" & Nomfichier
End If
PrintFichier (Nomfichier)
End Sub