View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L.Peter L.Peter is offline
external usenet poster
 
Posts: 2
Default save photos from a worksheet

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