Photo in a sheet
in [Programming]
|
From: Cheryl on 6 May 2010 15:40 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 Insert>Picture>From File... > > NickHK > > "mjones" <mjones(a)discussions.microsoft.com> wrote in message > news:8D192F10-336B-42C7-A8A6-81B60D815C08(a)microsoft.com... > > 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 > > > > > > > > >
From: Rick Rothstein on 6 May 2010 16:19 Can you show us the code you got from the macro recorder? -- Rick (MVP - Excel) "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message news:4660A9D8-9199-4697-AC30-911040626584(a)microsoft.com... > 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 Insert>Picture>From File... >> >> NickHK >> >> "mjones" <mjones(a)discussions.microsoft.com> wrote in message >> news:8D192F10-336B-42C7-A8A6-81B60D815C08(a)microsoft.com... >> > 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 >> > > >> > > >> >> >>
|
Pages: 1 Prev: Checking Cell Value for a Date Next: How to copy ActiveX Controls which are locked on a sheet |