|
用此方法切割,代码可以简化:
Sub 切割(ByVal Pt As String)
Dim sName$
Range("A1").Select
With ActiveSheet.Shapes.AddPicture(Pt, False, True, Selection.Left, Selection.Top, -1, -1)
.PictureFormat.CropBottom = .Height * 0.35 '底部被裁剪
sName = .Name '记录图片名称,以便后续操作
.Copy
End With
With ActiveSheet.ChartObjects.Add(0, 0, ActiveSheet.Shapes(sName).Width, ActiveSheet.Shapes(sName).Height).Chart
.Paste
.Export Pt
.Parent.Delete
End With
ActiveSheet.Pictures.Delete
End Sub
|
评分
-
查看全部评分
|