Excel中利用vba代码导出图片时以某一单元格内容重命名

Alt+F11 打开vba，选择工作簿后输入以下代码

Sub exportImg()
For Each oShape In ActiveSheet.Shapes
strImageName = oShape.TopLeftCell.Offset(0, -5).Value
oShape.Select
Selection.ShapeRange.PictureFormat.Contrast = 0.5: Selection.ShapeRange.PictureFormat.Brightness = 0.5: Selection.ShapeRange.PictureFormat.ColorType = msoPictureAutomatic: Selection.ShapeRange.PictureFormat.TransparentBackground = msoFalse: Selection.ShapeRange.Fill.Visible = msoFalse: Selection.ShapeRange.Line.Visible = msoFalse: Selection.ShapeRange.Rotation = 0#: Selection.ShapeRange.PictureFormat.CropLeft = 0#: Selection.ShapeRange.PictureFormat.CropRight = 0#: Selection.ShapeRange.PictureFormat.CropTop = 0#: Selection.ShapeRange.PictureFormat.CropBottom = 0#: Selection.ShapeRange.ScaleHeight 1#, msoTrue, msoScaleFromTopLeft: Selection.ShapeRange.ScaleWidth 1#, msoTrue, msoScaleFromTopLeft
Application.Selection.CopyPicture
Set oDia = ActiveSheet.ChartObjects.Add(0, 0, oShape.Width, oShape.Height)
Set oChartArea = oDia.Chart
oDia.Activate
With oChartArea
.ChartArea.Select
.Paste
.Export ("E:\cc\" & strImageName & ".png")
End With
oDia.Delete 'oChartArea.Delete
Next
End Sub

 

点击菜单栏：运行 =》运行子过程/用户窗体

Export ("E:\cc\" & strImageName & ".png") 为导出图片路径