Help inserting image based on URL from cell

[Sparky42]

I posted this the other day, but I realize now that it was in the wrong part of the forum.

OK, what I'm trying to do is set up a sheet that will generate a QR code from Google's API. I have the sheet set up so it will create a URL and want to insert the image that URL creates on a separate sheet. In theory, this would create images for each row in the inventory.

I have it set up so that these columns:


2711-P431209D2 | 1238470234 | 293847123

are fed into this formula:

=CONCATENATE("http://chart.apis.google.com/chart?cht=qr&chs=350x350&chl=",B2,"%2C",C2,"%2C",D2)

Which leads to this:

http://chart.apis.google.com/chart?c...53%2C02340-412

And from that I can insert this image:

Google Chart


What I'd like to be able to do is create a sheet of QR codes that I could print on some Avery labels to label inventory.

Basically, it is the same as telling Excel via VB to insert a pre-made image, but the address of the image is created in sheet1.

I just have no idea how to get VB to look at the cell with the address, and insert that image on to sheet2.

Any idea how I'd go about this?