Thread: Exporting chartobjects as JPEGs

Hi,

I just started Excel programming last week. I did some research online and I found out that we need to use the Export method to save charts as jpgs.

Here's the code I wrote but it's giving me an error saying

Runtime error: '438'

Object doesn't support this property or method

Here's the code snippet:

Code:

Public Sub ExportChartsToJpegs()
    
     Worksheets("TotBklg").ChartObjects("chart 1").Export Filename:="C:\DefectQuery\FEP4\Current\TotalBacklog" & FName & ".jpg", FilterName:="JPG"

    
End Sub

Hope someone can help me. Thanks!

Great! Thank you so much.