Change resolution (not dimension) of image

jcg31

Board Regular
Joined
Aug 20, 2006
Messages
176
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
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,723
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

Board Regular
Joined
Aug 20, 2006
Messages
176
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

Well-known Member
Joined
Jul 15, 2012
Messages
1,953
you can provide to all managers a folder with workbook and images
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,723
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,964
Members
413,955
Latest member
FalcoDaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top