Link A Picture

I want to place a picture (my company's logo) in several locations in an excel worksheet and I may have to change/replace the picture. My thought was to have a picture as an external file to link to a spreadsheet. Then if I change/replace the picture with the same name, it will automatically update the spreadsheet hopefully. Do you know how to link this picture to a worksheet ?

hi all,

i've tried several times to link a picture from one workbook to another ( in the same file) but without any effort.

i appreciate every answer

thanks in advance

I have a list of inventory items with item #'s and descriptions. I want to link each item # to an external directory full of picture files (jpg). How can I create a link that looks at the item # (ex. Nail123), in let's say A1, and returns a picture from a file named Nail123.jpg into B1? Thanks in advance.

when trying to insert a picture as an object without linking and not as an icon it doesn't matter what type of picture file i try to insert .bmp , .jpg the picture shows as an icon. the isnert picture as icon box is unticked. I found a temporary solution by converting the picture to a 24 bit bmp file but this as stopped working.
i'm using word 2003 with sp3 and office 2007 compatability pack installed .

can someone tell me how to get to see the picture i'mtrying to install rather than an icon.

I have a personel file, 1 row for each person. I want to have a picture of that person attached to a cell. Problem is that when I import the picture it takes up more than 1 row. Is there anyway to link the picture to a cell and when you click on that cell the appropriate picture enlarges?

Hello

I got an error with a programing line, and i just cant figure how to resolve it. System give me an 438 error


ActiveSheet.Picture.Insert(RANGE("SonrayPicture_Path") & Fname).Select


Whe
Range("SonrayPicture_Path") = name of the directory where the picture is based

Fname: Name of the picture file to be displayed

The purpose is to put a link to the selected cell and displayed the picture

Any help appreciated

Martin

I have a template which will be populated with data using vlookups to the datasheet. Stuff about animals. The data / text is fine, but at the top I need a picture representing the animal. How do I build a dynamic link to a picture? So you set an animals name using a drop down list and it goes and finds the image for that animal.

I tinkered with the following: using Copy, Shift+Edit / Paste Picture Link. This links the picture to an another worksheet. It has a refernce in the tool bar as =Anima!$A$1:$D$8. If you type over the worksheet name, then it pulls the image from another worksheet, e.g. animal2!. I planned to use the INDIRECT function so that I could change the worksheet name by referencing a cell in the worksheet (e.g. INDIRECT(SheetName&Range)). However, it wont work. I gives me "the text you entered is not a valid cell reference of name or defined name". The same function works fine in a cell but does not work with the paste picture link function. The worksheet it open, its just pulling from a workshet in the same workbook.

Any ideas about why this doesn't work, or a suggested alternative?

Thanks,

Hi.

How to make a picture appear depending on a value in a cell?
For example if the value is 1 then Picture no 1 is shown, and if the value is 2 then picture no one disappears and picture no 2 appears.

How Do I save a Camera Icon Dynamic Picture Link created in the Sheet itself?

Using the Camera Icon one can create a Images or Picture Links to the origjnal set of cells, now this Image or Picture is created in the Excel Sheet itself, now how Do i save this image to use it elsewhere?

Ex: Lets say I have 2 scenarios
1 Scenario: I have a rnage of numeric values in the range from A1 till C3 with the formula as = RAND()*100...

As the RAND function is used the value keeps on changing everytime I press F9..

Now using the Camera ICon I select the range of cells and paste it next to the OriginalRange as an Picture Link now true to its LINKING property it keeps on showing different values..


2.Scenario I have a Dynamic Picture in the cell A1 with some text at the Bottom of the Picture in the same cell i.e the Picture occupies the TOP portion and in the same cell at the bottome theres some space left intentionally left behind to show the TEXT alongwith the Image..

NOW on USING THE Camera ICon for the above 2 Scenarios I need to get the method to save the Dynamic Images..

Is this possiible and if yes then please provide an example..

Warm Regards
e4excel

How do I link a picture to a cell based on the response in a different cell? The picture would be saved as a file.

ie. Cells A1:A31 have the same dropdown list which populates C1:C31, D1:D31 and E1:E31. Based on the date entered into B1:B31, a table in T38:AH78 is popuated with data. Based on the results in E1:E31 (which would all be words or blanks), I would like a picture to appear in the table in the same cell as the word appears (ie over top of the word).

ie. if B2 populates cell T45 and E2 is Dog, then a picture a Dog would appear in the table.

The table populates correctly, I just don't know the code in VB to get the picture to appear.

So i have a userfrom with three pictures
a three pictures are hidden, a combobox with three selections will show the picture based on the value. Then when command button1 is pressed I want the picture showing to paste in cell D14 on Sheet "FULL ON-OFF"

I picture something like this (taken from the text)

Sheets("FULL ON-OFF").Range("d14") = Image7.Picture

but all this does is paste a number in that cell, not the picture. AND this is just always one picture, I need the picture showing (and only that picture) to show.
I guess all three could paste if needed, but as long as the one picture is the one overtop

is there a way in excel that if you type a name the picture linked to that would show

eg


1--a picture
2--a picture
3--a picture

etc
plz let me know if you know a way to this
thanks in advance

I am trying to inset a picture of North America into a tab in excel and still be able to type in the cells. I need to enlarge it so that I can fit some data on top of picture. I enlarge the picture by proportionally dragging the corners, but the picture sits on top of the cells, so I am not able to type in the cells. I tried to send the picture to the back, but didn't work.

I then tried to insert the picture as background, and it worked, but however, since the picture is small, the picture is displayed multiple time, much like a wallpaper on a desktop in tiles.

The question is: is there a way to insert the picture across all columns in excel? the next best option i konw is to enlarge the picture before inserting. Please let me know if you know of any clever way to do this. much appreciated.

Is there a way to change from having a link to a picture on a spreadsheet to actually having the picture showing? Without having to go to the picture and paste it into each row?

I'm desperate to not have to do this manually for like 100 different pictures. Any ideas would be awesome!

Thanks!

What is the code to just delete pictures which name start with "picture"?
so if we run th code: all the picture with name: picture 1, picture 2, picture 3 wil be deleted.
but not with picture named "house", "computer", etc

thank you

Hi,
I have a picture loaded on an userform. Is it possible to write a macro that copies the picture to the clipboard - when clicking on the picture ?
Purpose is to paste easily the picture afterwards in other MS Office applications.
Any suggestions ?
Thanks a lot.

Hi,
Having trouble with this.

First I set the picture

frmTest.imgB.Picture = frmIcons.Controls("img78").Picture

Then query it in the debug window

? frmTest.imgB.Picture

This gives me a number. But the number varies even though it's the same picture. Is it possible to get back the picture name, or some other means to determine if it's "img78" or something else?

Thanks.

Is there a way I can link text boxes to a picture, so when I move the picture it moves all the text boxes as well?

Hi,

I have a chart that has a picture pasted into it.

The name of this picture will constantly change (as it is copied and pasted based on various results)

I want to delete the picture from the chart before the next picture is pasted in.

Code:

    ActiveSheet.ChartObjects("Chart 15").Activate
    ActiveChart.Shapes("Picture 1").Select
    Selection.Delete

The above basic code will work if the picture is called "Picture 1", but how can I adapt it so it will delete whatever number the picture is?

Many Thanks.

Hi,

I have a macro that copy's a range in the workbook to a picture.

I wanted to rename the picture to "Picture1". I also have other pictures in the workbook. I think it is automatically called "Picture 1".

HTML Code:

Sub Create_PrintObject()
 
'Create the picture
Worksheets("Pol Value").Range("A1:J50").CopyPicture xlScreen, xlBitmap
 
'Rename the picture
 
End Sub

Do you know how to rename the picture to "Picture1"?

Thanks