title: Excel convert URL to images (1004)
body: <p>I have an excel document linked to an SQL database which contains several columns of image URLs.</p>
  
  <p>One of those URLs looks like this:
  <a href="https://imissit.blob.core.windows.net/iris/596480cf967e0c990c37fba3725ada0c/814040e2-0ccb-4b05-bdb3-d9dc9cc798d9/texture.png" rel="nofollow noreferrer">https://imissit.blob.core.windows.net/iris/596480cf967e0c990c37fba3725ada0c/814040e2-0ccb-4b05-bdb3-d9dc9cc798d9/texture.png</a>
  <a href="https://i.stack.imgur.com/e6xvN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e6xvN.png" alt="https://imissit.blob.core.windows.net/iris/596480cf967e0c990c37fba3725ada0c/814040e2-0ccb-4b05-bdb3-d9dc9cc798d9/texture.png"></a></p>
  
  <p>I found different approaches and methods on how to convert those URLs to images ( e.g. 
  <a href="https://stackoverflow.com/questions/15588995/excel-vba-insert-images-from-image-name-in-column/15589423">Excel VBA Insert Images From Image Name in Column</a> and <a href="https://superuser.com/questions/940861/how-can-i-display-a-url-as-an-image-in-an-excel-cell">https://superuser.com/questions/940861/how-can-i-display-a-url-as-an-image-in-an-excel-cell</a>) within the excel document using macros. I tried those approaches but none of them works for my kind of URL. I tried other URLs (random images on the web, http and https and for those images it WORKS).</p>
  
  <p>This is one of the snippets I tried, which works for other images:</p>
  
  <pre><code>   Sub InstallPictures()
      Dim i As Long, v As String
      For i = 2 To 2
          v = Cells(i, "O").Value
          If v = "" Then Exit Sub
          With ActiveSheet.Pictures
              .Insert (v)
          End With
      Next i
  End Sub
  </code></pre>
  
  <p>Anyway when trying it with my URL I get a runtime error 1004: Insert method of picture object cannot be executed(translated). Different approaches result in slightly different runtime errors (although 1004 is consistent).</p>
  
  <p>Here are some image URLs I tried that work:</p>
  
  <p><a href="https://docs.oracle.com/cd/E21454_01/html/821-2584/figures/HTTPS_Collab_Sample.png" rel="nofollow noreferrer">https://docs.oracle.com/cd/E21454_01/html/821-2584/figures/HTTPS_Collab_Sample.png</a></p>
  
  <p><a href="http://www.w3schools.com/css/paris.jpg" rel="nofollow noreferrer">http://www.w3schools.com/css/paris.jpg</a></p>
  
  <p><a href="https://scontent.ftxl1-1.fna.fbcdn.net/v/t1.0-9/13043727_278733959131361_2241170037980408109_n.jpg?oh=bec505696c5f66cde0cc3b574a70547c&amp;oe=58CC35C5" rel="nofollow noreferrer">https://scontent.ftxl1-1.fna.fbcdn.net/v/t1.0-9/13043727_278733959131361_2241170037980408109_n.jpg?oh=bec505696c5f66cde0cc3b574a70547c&amp;oe=58CC35C5</a></p>
  
  <p>What is different from my URL to the others and why those methods don't work? What is the correct approach?</p>