Hi Greg,

ActiveChart.Export Your_File_Path&Name, FilterName:="GIF"

Best Regards

Bill

-----Original Message-----
Hi!

We're using Excel to generate images of charts that go to
our user manuals.
Basically, we create the charts as embedded objects in a
worksheet, then
choose "Save As Webpage" to force Excel to save those
charts as GIF images.
The GIF images are numbered sequentially (e.g.,
image001.gif, image002.gif,
etc.). Our problem is, the filenames don't seem to
correspond to the correct
order of the charts. For example, we have 40 charts in
the page, and the
image filename generated for the first chart (going from
top to bottom) is
"image004.gif" instead of "image001.gif". Does anyone
know if there is any
way to control this so that we are able to
programmatically identify the
correct filenames?

Also, is there a way to have Excel save the images as BMP
instead of GIF?

Thank you so much for your help.

Greg


.