Excel pictures - saving to a file

[mish]

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]

Hi mish,

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

 

[Dean Southgate]

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

 

[Michelle Johnston]

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