Re : export d'un tableau au format PDF
nikel tous marche comme je voulais merci a tous , je ne pouvais pas mettre mon fichier il est un peu long et confidenciel, c'est sur que ça aurait été plus simple
encore merci a tous
voici la macro terminée
Sub export_pdf()
Dim moi As Integer
'moi = InputBox("Quel mois ")
moi = Range("d4")
Select Case moi
Case 1
Sheets("P01").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 2
Sheets("P02").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 3
Sheets("P03").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 4
Sheets("P04").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 5
Sheets("P05").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 6
Sheets("P06").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 7
Sheets("P07").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 8
Sheets("P08").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 9
Sheets("P09").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 10
Sheets("P10").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 11
Sheets("P11").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case 12
Sheets("P12").Select
Application.DisplayFullScreen = True
Chemin = "H:\ipcsr\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "tableau de travail.pdf"
Sheets("Menu").Select
Case Else
Sheets("Menu").Select
Application.DisplayFullScreen = True
'MsgBox "Je ne connais pas ce numéro de mois " & moi
End Select
End Sub