Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 209
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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


.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 209
Default 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


.


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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






  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 144
Default 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





  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting photo into a protected sheet Darrell R Moore Excel Discussion (Misc queries) 0 January 7th 11 04:25 PM
HOw do I set up a photo database? aggietwins03 Excel Discussion (Misc queries) 0 February 12th 07 07:03 AM
How do I insert a photo from my documant into my work sheet? Josh New Users to Excel 2 August 25th 06 08:00 PM
Link to a photo. grupy dyskusyjne Links and Linking in Excel 7 June 2nd 05 08:18 PM
photo gallery prmanoel Excel Discussion (Misc queries) 2 March 11th 05 11:00 PM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"