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.
Alternatively, by the chart name.
I managed to go as far as this:
Chart.Export Method (Excel)
Can anyone help?
Thanks in advance
Optimesh
(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.
Alternatively, by the chart name.
I managed to go as far as this:
Chart.Export Method (Excel)
Can anyone help?
Thanks in advance
Optimesh
(p.s. I have both office 2010 and 2013)