Sub 导出图片()
Dim i As Integer
Dim shp As Shape
Dim MySheet As Worksheet
For Each MySheet In ThisWorkbook.Worksheets
MySheet.Select
For Each shp In MySheet.Shapes
If shp.Type = msoPicture Then
i = i + 1
shp.Select
Selection.CopyPicture
With ActiveSheet.ChartObjects.Add(0, 0, shp.Width, shp.Height).Chart
.Paste
.Export ThisWorkbook.Path & "\" & i & ".jpg"
.Parent.Delete
End With
End If
Next
Next
End Sub