How to link to an image from one excel file to another

[second99]

I’m trying to figure out how to link to an image from one excel file to another. For example, see attached. When I try to link to that photo from another file, I get a 0 instead of the JPG. I'm using the formula pattern:

='C:\Users\smith\Desktop\[team_MASTER.xlsx]Sheet1'!$A$1

 

[pecoflyer]

Perhaps use a hyperlink instead?

 

[second99]

Perhaps use a hyperlink instead?

If I put the jpg on a server somewhere, what would be the code I would use in the excel cell to call and display that jpg?

 

[pecoflyer]

Sorry, my answer was wrong

 

[second99]

bump

 

[Peter Bartholomew]

This is far from being a speciality of mine!

My suggestion would be to extract the pictures as .jpg to a folder.
Then

Set p = ActiveSheet.Pictures.Insert( _
        "Path and file name").ShapeRange

Good luck