Sub RgptPh_Image()
Dim NmChemin As String
NmChemin2 = Sheets("Page de garde").Range("B4").Value
If Range("A1").Value = "" Then NumCode2
Dim Im As Picture
Dim NmPhoto As String
Selection.ShapeRange.Group.Select
Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 578#
Selection.ShapeRange.IncrementLeft -500#
Selection.ShapeRange.IncrementTop -500#
Selection.Copy
NmPhoto = Sheets("RgptPh").Range("A1").Value
'MsgBox "Photo numéro" & NmPhoto & ""
With ActiveSheet.ChartObjects.Add(0, 0, Selection.Width, Selection.Height).Chart
'.ChartArea.Border.LineStyle = 0
.Paste
End With
.Export NmChemin2 & "BasePlusA\" & NmPhoto & ".jpeg"
End With
End Sub