Since your first post did not specify whether you are exporting a chart or a picture within excel:
Try Andy Pope's add-in for exporting Pictures:
http://www.andypope.info/vba/gex.htm
or Aaron Bloods Chart to Picture exporter
http://www.xl-logic.com/pages/addins.html
These are both add-ins so you just have to load them to use. No vba on your part if that is outside your comfort level.
Quote:
|
Originally Posted by Dave Peterson
How about just selecting it, copying it, and pasting it into a different program
(Paint??) and saving from there?
If you're version of excel can save a file as "Web Page (*.htm;*.html)" (under
the "save as type" box on the File|SaveAs dialog), then when you save it, you'll
get a new folder with all the pictures under the folder with the file.
That new folder will be named like filename_Files.
If I recall correctly, this was added with xl2002.
SARANJAI wrote:
Tried to extract a picture from an Excel worksheet and save it as a *.jpg /
*.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same
goes for Word.
--
Dave Peterson
|