Dear people,

I am trying to get photo's from the internet into my excel worksheet.
It works when I am not using a variable as link path, but when I do it gives me errors.

I need to have it in a variable because I am grabbing the link out of an HTML source code.
That al works, but the ActiveSheet.Shapes.AddPicture (foto_link) gives me errors.

My code;
foto_link = ("http://lengersyachts.com/" & Foto_string)
ActiveSheet.Shapes.AddPicture (foto_link) _
, msoFalse, msoTrue, 400, 0, 775, 184

This code works;
ActiveSheet.Shapes.AddPicture "http://www.yachtworld.com/lengersyachts/images/L74812.jpg" _
, msoFalse, msoTrue, 0, 0, 475, 184


But I need to get that link read out of a variable
I already tried different variable data settings.

Please, can somebody help me out ?
Thank you in advance.