Linking drawing pics from internet

[iguzman]

If somebody can help me with this problem please, I'm trying to link t
my worksheet/catalog some drawings, in my worksheet I have th
manufacturer number of this drawings, so this could help when I writ
the number in the cell I want to call this drawing fro
internet/drawings catalog, if somebody know how to do it please let m
know.

Thanks in advance guys

 

[Ron de Bruin]

Try this

Sub Add_Picture_from_Website()
ActiveSheet.Shapes.AddPicture "http://www.rondebruin.nl/images/" _
& Range("A1").Value & ".jpg", msoTrue, _
msoFalse, 100, 100, 100, 50
End Sub

with in A1 the file name