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 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