Develop Excel Macro to Show Images from Online URL

excel vba import img from url

We integrated image import from cell URL. Whenever cell value changes, old image is deleted and fresh image is imported into target range properly sized and positioned.

06.12.2019, Goran Dolenc
Categories: Excel VBA
Tags: Excel Image Import URL VBA

A client from Hong Kong has reached us for the following job:

This is a purely Excel job for an Invoice generator. I have an Excel file that pulls images based on the SKU from an existing worksheet. I have too many images and don't want to store them in the worksheet anymore. I want help to create a macro or a solution to my existing Excel spreadsheet and replace it by displaying images from an online URL. All the images are available online and the URL can be predictably generated. The job is to display the image in Excel using this generated URL.

This is the Excel sheet, where he wanted us to import the images to:


And here is another sheet in the same Excel workbook file, where client has URL for the front and back image of the mobile phones they are selling. We import images from URL provided in these two cell into the predefined target range.