I want to export an Excel chart image as a JPG. I can do this easily with the following code:
Worksheets("Sheet1").ChartObjects(1) _
.Chart.Export _
Filename:="current_sales.jpg", FilterName:="JPG"
This works a treat.
My problem is, I want to be able to tweak the JPG save quality. If I use the Interactive:=True option which should ‘display the dialog box that contains the filter-specific options’, no dialog box is displayed (and anyway, even if it was, I’d want to control those properties programmatically).
Does anyone know how I can send that value to the filter?
Perhaps the normal chart-to-jpg filter doesn’t support any options. Does anyone know of other filters I could use that would achieve this?
Thanks in advance for all your help.
Peter
