How can I export charts as graphics sequentially?

[wibsy]

Hi all,

I'm trying to export a number of graphs (as gifs) from a single
worksheet.

I was planning to automatically name them sequentially i.e.
export1.gif, export2.gif etc, based on their position on the
worksheet.

I've tried using the index property to export the charts, however there
are a couple of charts near the bottom of the sheet that have a lower
index number than those above, so they come out in the wrong order.

I believe the index property is read only, which I guess means I can't
re-index them in the correct order......Is there another way to do this
?

Thanks

Wibsy

 

[Nivek]

I can tell you how to make your file so that it is not read only, but other
than that I can't help you much.

To make a file not "read only":
1. Click your start menu
2. Click "All Programs"
3. Click "Accessories"
4. Click "Windows Explorer"
5. Find your file
6. Right click your file
7. Move your mouse down to "Properties" and click it
8. Down at the bottom of the Properties window click the box beside "Read
Only"

Nivek

 

[Tushar Mehta]

Consider naming each chart yourself. Well, more accurately, it might
make more sense to name the chart containers (i.e., the chartobject).

Select any cell. Then, hold SHIFT and click a chart. This will
actually select the chartobject containing the chart. In the name box
(extreme left of the formula bar) enter a name and press ENTER.

Now, your code and process the charts in the desired sequence based on
the names.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions