用VBA导出Excel里的图表为JPG文件

最新推荐文章于 2023-11-15 17:05:54 发布

转载最新推荐文章于 2023-11-15 17:05:54 发布 · 2.5k 阅读

WORD-VBA 专栏收录该内容

10 篇文章

订阅专栏

本文详细介绍了如何使用VBA代码将Excel图表导出为JPG文件，包括设置工作簿路径、获取指定图表对象并进行导出操作。

Sub ExportChart()
    Dim myChart As Chart
    Dim myFileName As String
    Set myChart = Sheet1.ChartObjects(1).Chart
    myFileName = "myChart.jpg"
    On Error Resume Next
    Kill ThisWorkbook.Path & "/" & myFileName
    myChart.Export Filename:=ThisWorkbook.Path & "/" & myFileName, Filtername:="JPG"
    MsgBox "OK"
    Set myChart = Nothing
End Sub

转自 http://blog.youkuaiyun.com/laoyebin/article/details/5741671