Sub essai()
Vers_où = Selection.Text
'Ouverture du classeur
Set Planning = Workbooks.Open("C:\Users\Toto\Documents\Toto.xlsx")
ActiveWorkbook.Sheets(Vers_où).Activate
Planning.Sheets(Vers_où).Select
Range("B2:H34").Select
Selection.Copy
Planning.Close False
Sheets("Feuil1").Select
Range("K20").Select
ActiveSheet.Paste
Dim fichier As String, Dossier As String, Chemin As String
With Sheets("Feuil1")
fichier = "\" & Range("K1") & ".pdf"
Dossier = "C:\Users\Toto\Documents\Excel"
Chemin = Dossier & fichier
End With
Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub