getting an image from an URL

[Rury15]

Hello excel gurus,
I have a table in SQL with some fields, and one of this fields is a URL. I need to show all of the info in the table in excel, but I want the URL field to show the image the URL is pointing to instead of the URL itself. How can I show the image at a certain URL in Excel? I need an automatized process because theres more than 10k rows , thank you and sorry for my bad english

 

[VBA Geek]

adding the pic is easy, you would do:

Sub InsertPic()
Const URL$ = "http://harmonieweertzuid.nl/wp/wp-content/uploads/2015/01/excel.png"


Sheets(1).Shapes.AddPicture URL, msoFalse, msoTrue, Range("A1").Left, Range("A1").Top, Range("A1").Width, Range("A1").Height
End Sub

 

[antialias401]

Andre Poulsom shares his expertise on adding mass images via URL in the link below.

Especially look at Post #19, it is the real deal.
I've used his Image via URL advice in the past with amazing results.
Hopefully it helps you too...

http://www.mrexcel.com/forum/excel-questions/604604-insert-image-url-images-into-cells.html

Regards