@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.
- Forums
- Test
- vba