Inserting photos into excel cell

M

Mark

I'm trying to build a database that includes photo for each
person. I'm using listwizard in Excel Mac:2001 and cannot
figure out how to insert a photo into a cell. Whenever I
insert:picture:from file, the photo is not associated with
any particular cell. Therefore, I cannot data merge the
photos along with the rest of the fields.
 
J

JE McGimpsey

Mark said:
I'm trying to build a database that includes photo for each
person. I'm using listwizard in Excel Mac:2001 and cannot
figure out how to insert a photo into a cell. Whenever I
insert:picture:from file, the photo is not associated with
any particular cell. Therefore, I cannot data merge the
photos along with the rest of the fields.
Click to expand...

You're exactly right. In XL, cells can only contain values or formulas.
Inserted pictures live in the drawing layer above the cells.

What you're doing is more the job of a database application than a
spreadsheet.

You might be able to insert the path and filename into a cell and use
that, depending on what application you're merging to.
 
J

Jim Gordon MVP

McGhee is gonna kill me for saying this, but I think the ancient slide-show
add-in does this. There used to be a code sample of how to do it, probably
in the Excel 95 software development kit, which I don't have.

-Jim
 
Top