exporting multiple charts as images

Hi,

I'm using the follwing code snippet to export the first chart in my workseheet as a gif file:

Please Login or Register  to view this content.

1) how can i edit this to use the chart name that is assigned in excel (under Layout->Properties in excel2007...the default is 'Chart 1' right now) to name the file? I noticed this is different from the actual chart Title.

2) how can i edit this to make it export every chart in the worksheet?

The goal would be to run the macro and have it export every chart on the worksheet, saving them with their chart names as their filenames.

Thanks

Please Login or Register  to view this content.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.