Make a picture dynamic

[Jaymond Flurrie]

I have inserted a picture into a sheet, just by using Insert -> Picture (In Excel 2007). Now I have the picture there, I have formatted it properly and it looks totally fine. It's also the only picture in the whole workbook, has name MyPicture.

How do I make it dynamic? I mean, my user decides to change the picture I used as the source picture (say, C:\pic.jpg) and I want this picture in the sheet to be linked so that it check itself from the file location, say, everytime I open the workbook.

I know how to create code that is based on events, so really, what I'm looking for is the correct property and the way to change it. Something like:

ActiveSheet.Shapes(1).FileSource = "C:\pic.jpg"

 

[Jaymond Flurrie]

Anyone?

 

[Marcelo Branco]

Maybe something like

ActiveSheet.Pictures.Insert ("C:\Pictures\MyPicture.png")

-Edit-
Sorry, i misunderstood your OP
You need to assign the pic to a shape


M.

 

[Jaymond Flurrie]

Maybe something like

ActiveSheet.Pictures.Insert ("C:\Pictures\MyPicture.png")

HTH

M.

Yeah, I think I can work with that, I just delete the picture when the workbook closes.

Thanks!

 

[Marcelo Branco]

Yeah, I think I can work with that, I just delete the picture when the workbook closes.

Thanks!

Hi,

I thought you would like to assign it to a Shape, but i can't figure out (till now) how to do this.

M.

 

[Jaymond Flurrie]

Hi,

I thought you would like to assign it to a Shape, but i can't figure out (till now) how to do this.

M.

Another option is to use ActiveX component and do it like:

Sheet1.imgPicture.Picture = LoadPicture(ThisWorkbook.Path & "\MyPicture.jpg")

in the open event of workbook.

Whether I really lose something very important by using ActiveX instead of a shape, I don't know.