Screen Capture All Charts In Workbook

[goss]

Hi all,

Using Excel 2010.
I tried exporting charts in the workbook as .jpg images
However, the image quality is not as good as if I use SnagIt to screen capture the image and export as a .jpg image.

But to manually export 200 images is painful.
Is anyone aware of a utility or API with SnagIt or other screen capture to automate this process?

 

[SydneyGeek]

Not my idea, but quick...
Save the workbook as HTML. Go to the folder where you saved the file, and all graphical objects will be in there as jpg files (full size and thumbnail). By browsing the files using Picture Viewer you should be able to locate all the charts.

An alternative is an add-in created by Jon Peltier -- http://peltiertech.com/WordPress/enhanced-export-chart-procedure/


Denis

 

[Jon Peltier]

You also should try using the PNG image file format, which was designed for computer line art. JPG was designed for photographic images, and has troubles with sharp color transitions.