Inserting photos into excel cell

[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
inserticture: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.

 

[JE McGimpsey]

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
inserticture: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.

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.

 

[TKT-Tang]

Mr. Mark,

Please refer to the following article :-

http://www.contextures.com/xlcomments02.html#Picture

That's adding photographs on to the Comments of worksheet cells.

Regards.

 

[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