vba

  1. 1,487 Posts.
    lightbulb Created with Sketch. 65
    @Jako64

    I noticed you post a few excel charts. In case it's of value here's some code to automate chart saving in a consistent format:

    Sub Save_Chart()
    Dim myChart As Chart: Set myChart = ActiveChart
    Dim fn: fn = "C:\temp\CH_" & InputBox("FileName", "CH_", "") & ".JPG"
    myChart.Export Filename:=fn, Filtername:="JPG"
    End Sub

    Obviously the file location needs to be changed to suit your needs.
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.