Excel pictures - saving to a file
 

Hi
I have a number of excel files that have pictures in them. I need to
be able to save them to files - jpg or gif or whatever - I cant work
out how to do this, even just using Excel, let alone using VBA? Does
anyone know how I save JUST THE PICTURE SELECTED as a graphics file of
some kind?
Any help gratefully appreciated!!!
Thanks
Michelle

Excel pictures - saving to a file
 

Hi mish,

No built-in method, at least in the versions I have.
But this may help.
(http://www.andypope.info/vba/gex.htm)

mish wrote:

Hi
I have a number of excel files that have pictures in them. I need to
be able to save them to files - jpg or gif or whatever - I cant work
out how to do this, even just using Excel, let alone using VBA? Does
anyone know how I save JUST THE PICTURE SELECTED as a graphics file of
some kind?
Any help gratefully appreciated!!!
Thanks
Michelle

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Excel pictures - saving to a file
 

The only answer I can think of and use, is to copy and
paste the picture into a graphics program, then save as
whatever format I need.

Regards
Dean
-----Original Message-----
Hi
I have a number of excel files that have pictures in
them. I need to
be able to save them to files - jpg or gif or whatever -
I cant work
out how to do this, even just using Excel, let alone
using VBA? Does
anyone know how I save JUST THE PICTURE SELECTED as a
graphics file of
some kind?
Any help gratefully appreciated!!!
Thanks
Michelle
.

Excel pictures - saving to a file
 

Thanks a lot Andy for your reply.. very prompt too! It is so nice to
actually get a reply to a question I have placed!
I will try that graphic exporter tool!
I had been doing it in a really naff way up until now - copying and
pasting into powerpoint and then saving in powerpoint as jpg! Yeuk!

I will take a look
Thanks
Michelle

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!