Controlling image filenames during "Save As Webpage" ...
 

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

Controlling image filenames during "Save As Webpage" ...
 

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


.

THANKS, BILL! ( Controlling image filenames during "Save As Webpage" ...)
 

Bill:

Your solution worked. Thanks a lot for oyur help.

However, I still need to figure out how to convert those GIF images into BMP
format. I tried the following, but it did not work:

ActiveChart.Export v_filepath, FilterName:="BMP"

Thanks again.

Greg

"Greg_Del_Pilar" wrote in message
news:0Y2gb.29159$6C4.25875@pd7tw1no...
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