Convert URL to Image Excel | URL to IMAGE

This can be achieved in Excel using the Macros.

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I ALT-M opens a fresh module
3. Paste the stuff in and close the VBE window

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

Sub InsImg()

    Dim URL As Range

        

    For Each URL In Range("F2", Cells(Rows.Count, "F").End(xlUp))

        With URL.Parent.Pictures.Insert(URL.Value)

            .Left = URL.Offset(0, 1).Left

            .Top = URL.Offset(0, 1).Top

            URL.EntireRow.RowHeight = .Height

        End With

    Next

End Sub

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

In above code F2 is name of the cell in which URL is present.

When you will start conversion it will continuously go and hit the Google , if the URL's in large amount then it will through an error after few minutes.

If you save the workbook, the macro will be saved with it. If you are using a version of Excel later then 2003, you must save the file as .xlsm rather than .xlsx

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

and

http://msdn.microsoft.com/en-us/library/ee814735(v=office.14).aspx

Macros must be enabled for this to work!