Sub MetLimage()
'Crépy en Valois'
Set LeGraph = Worksheets("Crépy").ChartObjects(1).Chart
NomImage = ThisWorkbook.Path & Application.PathSeparator & "temp.gif"
Set LeGraph2 = Worksheets("Crépy").ChartObjects(2).Chart
NomImage2 = ThisWorkbook.Path & Application.PathSeparator & "temp2.gif"
Set LeGraph3 = Worksheets("Crépy").ChartObjects(3).Chart
NomImage3 = ThisWorkbook.Path & Application.PathSeparator & "temp3.gif"
Set LeGraph4 = Worksheets("Crépy").ChartObjects(4).Chart
NomImage4 = ThisWorkbook.Path & Application.PathSeparator & "temp4.gif"
Set LeGraph5 = Worksheets("Crépy").ChartObjects(5).Chart
NomImage5 = ThisWorkbook.Path & Application.PathSeparator & "temp5.gif"
LeGraph.Export Filename:=NomImage, FilterName:="GIF"
LeGraph2.Export Filename:=NomImage2, FilterName:="GIF"
LeGraph3.Export Filename:=NomImage3, FilterName:="GIF"
LeGraph4.Export Filename:=NomImage4, FilterName:="GIF"
LeGraph5.Export Filename:=NomImage5, FilterName:="GIF"
UserForm1.MultiPage1.Pages(0).Image1.Picture = LoadPicture(NomImage)
UserForm1.MultiPage1.Pages(0).Image2.Picture = LoadPicture(NomImage2)
UserForm1.MultiPage1.Pages(0).Image3.Picture = LoadPicture(NomImage3)
UserForm1.MultiPage1.Pages(0).Image4.Picture = LoadPicture(NomImage4)
UserForm1.MultiPage1.Pages(0).Image5.Picture = LoadPicture(NomImage5)
'Acy en Multien'
Set LeGraph7 = Worksheets("Acy").ChartObjects(1).Chart 'ChartObjects(1) fait référence au premier ChartObject de la feuille et pas à sa propriété Name)
NomImage7 = ThisWorkbook.Path & Application.PathSeparator & "temp7.gif"
Set LeGraph8 = Worksheets("Acy").ChartObjects(2).Chart
NomImage8 = ThisWorkbook.Path & Application.PathSeparator & "temp8.gif"
Set LeGraph9 = Worksheets("Acy").ChartObjects(3).Chart
NomImage9 = ThisWorkbook.Path & Application.PathSeparator & "temp9.gif"
LeGraph7.Export Filename:=NomImage7, FilterName:="GIF"
LeGraph8.Export Filename:=NomImage8, FilterName:="GIF"
LeGraph9.Export Filename:=NomImage9, FilterName:="GIF"
UserForm1.MultiPage1.Pages(1).Image7.Picture = LoadPicture(NomImage7)
UserForm1.MultiPage1.Pages(1).Image8.Picture = LoadPicture(NomImage8)
UserForm1.MultiPage1.Pages(1).Image9.Picture = LoadPicture(NomImage9)
End Sub