LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically adding image extension ".jpg" to end of image name Alain Excel Discussion (Misc queries) 3 June 19th 08 03:21 PM
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION yossie6 Excel Discussion (Misc queries) 1 June 16th 08 12:16 PM
Excel adds a "1" to filenames opened from desktop shortcut skibeaux Excel Discussion (Misc queries) 4 June 20th 07 09:05 PM
"Save" and "Save As" options greyed out - "Save as Webpage" option Bill Excel Discussion (Misc queries) 0 January 16th 07 04:47 PM
"Save As WebPage" dialog box missing Luis Excel Discussion (Misc queries) 2 August 31st 06 09:54 AM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"