save photos from a worksheet

  • Thread starter Thread starter L.Peter
  • Start date Start date
L

L.Peter

Dear Group,
i have a xls file (excel 2000) with the following layout
a1: id001
b1: Picture file (*.jpg), what user did was: click to b1 cell, then insert a
jpg file.
a2: id002
b2: picture file
.....
a200: id200
b200: picture file

my task now is to go through cells B1 to B200 and copy them, open mspaint
then paste them, save them as id001.jpg to id200.jpg

Question: Is there any way to script this routine?

TIA

L.Peter
 
You cannot insert a picture into a cell. An image sits as a new layer on the
worksheet.Pictures are members of the Shapes collection
 
Thanks Bernard for that info. So is there any way i can save the
worksheet.pictures to another jpg file?

TIA

Peter
 
Back
Top