Insert Property of Picture Class

Question

I have read all of the questions on here about this topic and none of them provided me with a workable solution, so I'm asking this one. I am running a legitimate copy of Excel 2013 in Windows 7. I record a macros where I insert a picture, and in the open file dialog I paste this URL: `http://ecx.images-amazon.com/images/I/41u%2BilIi00L._SL160_.jpg` (simply a picture of a product on Amazon). This works as expected. The resulting macros looks like this: ``` Sub insertImage() ' ' percent Macro ' ' ActiveSheet.Pictures.Insert( _ "http://ecx.images-amazon.com/images/I/41u+ilIi00L._SL160_.jpg").Select End Sub ``` However, when I attempt to run this, the `Insert` line breaks with the following error: ``` Run-time error '1004': Unable to get the Insert property of the Picture class ``` I am trying to insert a number of pictures into an excel document and I am using the `ActiveSheet.Pictures.Insert` method to do this. I have been experiencing this issue there, so I recreated it in a way other…

Accepted Answer

Try this workaround:

```
Sub RetrieveImage()
Dim wsht As Worksheet: Set wsht = ThisWorkbook.ActiveSheet
wsht.Shapes.AddPicture "http://ecx.images-amazon.com/images/I/41u+ilIi00L._SL160_.jpg", _
                    msoFalse, msoTrue, 0, 0, 100, 100
End Sub
```

All fields are required, which is kind of a bummer since you cannot get the default size. The location offsets and sizes are in pixels/points. Also, the `%` turning to `+` is just alright, as `%` would cause it to be not recognized (dunno why).

Result:

Let us know if this helps.

Insert Property of Picture Class

Solution

Problem