I have a VBA script that runs through a series of number on a series of worksheets and creates a ton of charts (432 per worksheet). Each chart is created and then converted to an image (for use in a number of other applications) and place on a separate worksheet with 18 pages that a three across and 8 deep per page. This makes each chart readable (given the load of numbers also displayed) but any smaller would be a problem. The problem is that the file size is huge.
So I was excited to find the the image size an quality option under advanced options. Unfortunately changing that setting to 220ppi and then running and saving the chart and then changing that setting to 96 ppi, runing the charts and saving the file produce files precisely the same size.
Can anyone tell me how to change the image resolution (not the dimension) using vba?
Thanks for any help.
Jim
So I was excited to find the the image size an quality option under advanced options. Unfortunately changing that setting to 220ppi and then running and saving the chart and then changing that setting to 96 ppi, runing the charts and saving the file produce files precisely the same size.
Can anyone tell me how to change the image resolution (not the dimension) using vba?
Thanks for any help.
Jim