Change resolution (not dimension) of image

[jcg31]

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

 

[patel45]

you can not

 

[NdNoviceHlp]

Why keep all the charts and images in the wb? After the chart has been created and exported as an image, it is a file that can be stored at any directory. After the chart is stored why do you need to keep it in the wb... a picture of it can be recalled from the directory it is stored in and displayed in an image control. HTH. Dave

 

[jcg31]

Why keep all the charts and images in the wb? After the chart has been created and exported as an image, it is a file that can be stored at any directory. After the chart is stored why do you need to keep it in the wb... a picture of it can be recalled from the directory it is stored in and displayed in an image control. HTH. Dave

Good suggestion but the workbook is used as a reference for the manager of each business location (there are 13 locations). Each chart is associated with a particular business location and line item from their chart of accounts and depicts performance for lastyear, this year and plan. Each chart is also created with a link, so when a particular chart is clicked, a study sheet is created in the workbook that compares a particular line item across all properties. So if the "Production Maintenance" chart is clicked, the study tab is created and presents the Production Maintenance chart for all 14 properties for easy comparison across all properties.

 

[patel45]

you can provide to all managers a folder with workbook and images

 

[NdNoviceHlp]

Maybe delete all charts & pics before workbook close and then generate all new charts and pics on workbood open ie. don't save the wb with charts and pics in it. Sorry only practical solutions. I don't think changing the image resolution will help (if you can do it). Good luck. Dave