Photo in a sheet

[Guest]

Maby a strange question
I know how to put a photo in a sheet
but can i have the name of the photo as variabel?

Like if Bobby login then the photo of bobby comes on the sheet
and if is Lisa then its lisas photo

Best regards alvin

 

[Guest]

hi
http://www.mcgimpsey.com/excel/lookuppics.html
this site might give you some ideas
use application.username to find out who is logged on.
application.username would be your variable.
good luck

 

[Guest]

Thanks its working

Alvin


"(e-mail address removed)" skrev:

 

[Guest]

So how do you put a photo in a sheet. I really want to learn that.

 

[NickHK]

Record a macro whilst you do the actions of Insert>Picture>From File...

NickHK

 

[Cheryl]

I recorded a macro while going through the steps of insert\picture\from file,
but nothing happens when I run it. I've written several other macros that
work just fine, but this one does butkus. The photo is on a shared network
drive, if that makes any difference.

 

[Rick Rothstein]

Can you show us the code you got from the macro recorder?