| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
save photos from a worksheet
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 -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "L.Peter" wrote in message .. . 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
save photos from a worksheet
Thanks Bernard for that info. So is there any way i can save the
worksheet.pictures to another jpg file? TIA Peter "Bernard Liengme" wrote in message ... 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 -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "L.Peter" wrote in message .. . 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save only active worksheet without save all of worksheet | Excel Worksheet Functions | |||
| When you hit Save on a template, how can you save as worksheet? | Excel Worksheet Functions | |||
| How can I programatically change photos in one worksheet | Excel Discussion (Misc queries) | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions | |||
Hybrid Mode
