View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg_Del_Pilar Greg_Del_Pilar is offline
external usenet poster
 
Posts: 3
Default 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