Photo in a sheet
 

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

Photo in a sheet
 

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

-----Original Message-----
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


.

Photo in a sheet
 

Thanks its working

Alvin


" skrev:

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

-----Original Message-----
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


.

Photo in a sheet
 

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

"Alvin Hansen" wrote:

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

Photo in a sheet
 

Record a macro whilst you do the actions of InsertPictureFrom File...

NickHK

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

"Alvin Hansen" wrote:

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

Photo in a sheet
 

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.

"NickHK" wrote:

Record a macro whilst you do the actions of InsertPictureFrom File...

NickHK

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

"Alvin Hansen" wrote:

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

Photo in a sheet
 

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

--
Rick (MVP - Excel)



"Cheryl" wrote in message
...
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.

"NickHK" wrote:

Record a macro whilst you do the actions of InsertPictureFrom File...

NickHK

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

"Alvin Hansen" wrote:

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