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

  • Thread starter Thread starter Greg_Del_Pilar
  • Start date Start date
G

Greg_Del_Pilar

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
 
Hi Greg,

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

Best Regards

Bill
 
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
 
Back
Top