Option Explicit
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 Const SW_SHOWNORMAL = 1
Sub Tst()
Dim sFichier As String
Dim hwnd As Long
sFichier = ThisWorkbook.Path & "\" & Feuil1.Range("A1")
With Feuil2
.Activate
.Cells.Clear
.Range("A1").Select
End With
ShellExecute hwnd, "Open", sFichier, 0&, 0&, SW_SHOWNORMAL
Application.Wait (Now + TimeValue("0:00:05"))
SendKeys "^a", True
SendKeys "^c", True
ActiveSheet.Paste
SendKeys "^v"
Shell "Taskkill /im Acrobat.exe /f", 0
End Sub