Export charts and name the file by the charts title

Optimesh

New Member
Joined
Sep 19, 2012
Messages
18
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)
 

Forum statistics

Threads
1,086,243
Messages
5,388,668
Members
402,134
Latest member
McKnze21

Some videos you may like

This Week's Hot Topics

Top