Inserting multiple images from a unique URL to a word document via VBA

[simon1985]

Hi Guys

I am trying to put together a macro that will insert multiple images into a new Word document. The images themselves are from a website URL, the URL which is concatenation of a URL and the data in column A.

Row 1 of my workbook is all headings. The URL I am using is "http://qrcode.kaywa.com/img.php?s=8&d=" with the value of Column A, starting at A2 and working its way down (to the last value).

As an example, A2 contains the data 1-85858, so the URL image will be http://qrcode.kaywa.com/img.php?s=8&d=1-85858.

In addition, I would like to be able to insert below each image the data that is respective Columns B and C (First and Last Name).

I've done some work on it and am having difficulties getting all of the images into one word document.

Please Login or Register  to view this content.

The Word document itself doesn't have to save anywhere, can be saved by the user later on.

Attached is an Example of the Data (Excel Document where I would like to run the VBA from) and an Example of the Output I am looking for.

I appreciate any assistance.

Example Data.xlsxExample Output.doc

Regards,
Simon