Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically adding image extension ".jpg" to end of image name | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Excel adds a "1" to filenames opened from desktop shortcut | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
"Save As WebPage" dialog box missing | Excel Discussion (Misc queries) |