Hi all,
I was wondering if someone knows how to do the following, or can refer to an implementation of such a thing.
I have an excel file with many sheets and charts scattered in the various sheets.
I'd like to export all charts to a folder as image files.
I'd like the file names to be determined by the chart title / chart name.
A friendly guy over at excelforum.com created a VBA to do that, but it fails to export some of the charts and I'm stuck.
see here:
Export charts from an excel file as images and name the image files by the charts title
Can anyone help?
Thanks in advance
(p.s. I have both office 2010 and 2013)
I was wondering if someone knows how to do the following, or can refer to an implementation of such a thing.
I have an excel file with many sheets and charts scattered in the various sheets.
I'd like to export all charts to a folder as image files.
I'd like the file names to be determined by the chart title / chart name.
A friendly guy over at excelforum.com created a VBA to do that, but it fails to export some of the charts and I'm stuck.
see here:
Export charts from an excel file as images and name the image files by the charts title
Can anyone help?
Thanks in advance
(p.s. I have both office 2010 and 2013)